{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Cash Flow (Crops)","Cash Flow (Livestock)","Cash Flow (Crops & Livestock)","Printable (Crops)","Printable (Livestock)","Printable (Crops & Livestock)","Chart Drivers","Optimization","Chemical Master List"],"not_rendered":{"charts":18,"images":6,"macros":1,"external_links":1,"defined_names":58,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,4,12,17],[4,0,4,17],[0,0,2,17],[11,4,11,17],[6,0,6,17],[5,0,5,17],[3,0,3,17]]}
["Cash Flow Estimator"]
[]
[]
["Template by: Jon LaPorte, Farm Management Educator"]
["Michigan State University Extension"]
["Suite 116, 120 N. Broadway, Cassopolis, MI 49031"]
["Phone: (269) 445-4356          Email: laportej@msu.edu"]
[]
[]
["1)","Click on the next TAB to enter specific expense (or income) information."]
[]
[null,null,"Cash Flow ","-","Input income and expense budget information to create an estimated cash flow for your farm.  These pages are printable."]
[null,null,"Printable","-","A printable copy of only the \"total\" income and expenses for your combined enterprises."]
[]
["2)","Only items that are colored in BLUE should be altered in each TAB.  Changing the value of an item not marked BLUE can cause the formulas in the spreadsheet to stop working."]
[]
[null,"Note: This is a Macro-based Excel program.  If your software does not support Macros, the reset buttons on each Cash Flow page will not function, but all other cells will."]

{"sheet":"Cash Flow (Crops)","index":1,"n_rows":129,"n_cols":32,"rows_kept":129,"cut":false,"hidden":false,"merged":[[6,19,7,25],[0,2,1,12],[4,2,4,3],[4,5,4,6],[4,8,4,9],[4,11,4,12],[4,14,4,15],[12,19,12,24],[13,19,13,24],[14,0,15,0],[14,1,15,1],[66,0,66,17],[83,0,83,9],[101,0,101,17],[118,0,118,9],[128,0,128,9],[0,14,0,17],[75,0,75,9],[5,2,5,3],[5,5,5,6],[5,8,5,9],[5,11,5,12],[5,14,5,15]]}
[null,null,"Cash Flow Estimator",null,null,null,null,null,null,null,null,null,null,null,"Farm Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":"Crop 2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I5","v":"Crop 3"}]
["(Enter Crop/Livestock Enterprise) -->",null,"Crop 1",null,null,"Crop 2",null,null,"Crop 3",null,null,"Crop 4",null,null,"Crop 5",null,null,"Total Cash Flow",null,null,null,null,null,null,null,"Drop Down Menu"]
["(drop down menu) ->",null,"After Soybeans",null,null,"After Corn",null,null,"After Soybeans",null,null,"After Corn",null,null,"After Corn",null,null,null,null,null,null,null,null,null,null,"After Soybeans"]
["INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flow Estimator"]
["Gross Revenue"]
["Value Per Unit (i.e., bushel, cwt, ton)",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit"]
["Average Units (i.e., bushels, cwt, tons)",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,"Production Revenue"]
["Size of Enterprise (i.e., acres)",null,0,"Acres",null,0,"Acres",null,0,"Acres",null,0,"Acres",null,0,"Acres",null,{"$f":"(C9*C10*C11)+(F9*F10*F11)+(I9*I10*I11)+(L9*L10*L11)+(O9*O10*O11)","v":0}]
[]
["Government Payments",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C13*$C$11)+(F13*$F$11)+(I13*$I$11)+(L13*$L$11)+(O13*$O$11)","v":0},null,"Prepared by: Jon LaPorte, Farm Business Management Educator"]
["Other Income",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"Suite 116, 120 N. Broadway, Cassopolis, MI 49031"]
["Gross Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise Totals"]
[null,null,{"$f":"(C9*C10)+C13+C14","v":0},null,null,{"$f":"(F9*F10)+F13+F14","v":0},null,null,{"$f":"(I9*I10)+I13+I14","v":0},null,null,{"$f":"(L9*L10)+L13+L14","v":0},null,null,{"$f":"(O9*O10)+O13+O14","v":0},null,null,{"$f":"SUM(R11,R13:R14)","v":0}]
["EXPENSE"]
["Variable Costs"]
["Seed",null,0,{"$f":"C19","v":0},null,0,{"$f":"F19","v":0},null,0,{"$f":"I19","v":0},null,0,{"$f":"L19","v":0},null,0,{"$f":"O19","v":0},null,{"$f":"(C19*$C$11)+(F19*$F$11)+(I19*$I$11)+(L19*$L$11)+(O19*$O$11)","v":0}]
["Fertilizer",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Nitrogen",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C21*$C$11)+(F21*$F$11)+(I21*$I$11)+(L21*$L$11)+(O21*$O$11)","v":0},null,null,null,null,null,null,null,{"$f":"2000*U21","v":0}]
["Phosphorus",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,{"$f":"2000*U26","v":0}]
["Potassium (Potash)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Sulfur",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Limestone",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other Fertilizer (i.e. micronutrients)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,{"$f":"2000*U22","v":0}]
["Crop Chemicals",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"2000*U27","v":0}]
["Herbicides",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,{"$f":"2000*U28","v":0}]
["Fungicides",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Insecticides",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Crop Insurance",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Crop Miscellaneous",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Supplies",null,0,0,null,0,0,null,0,0,null,0,{"$f":"L33","v":0},null,0,{"$f":"O33","v":0},null,0]
["Gas/Fuel",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Equipment Fuel",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Drying Propane",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C36*$C$11)+(F36*$F$11)+(I36*$I$11)+(L36*$L$11)+(O36*$O$11)","v":0}]
["Repairs & Maintenance",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,"lbs/ton",{"$f":"2000*(U40/100)","v":0},{"$f":"2000*(V40/100)","v":0},null,{"$f":"SUM(AB37:AC37)","v":0}]
["Repair, Machinery",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,null,"%/ton",{"$f":"AB37/(AB37+AC37)","v":{"$error":"#DIV/0!"}},{"$f":"AC37/(AB37+AC37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AB38:AC38)","v":{"$error":"#DIV/0!"}}]
["Repair, Buildings",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Custom Hire",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Driver & Equipment Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Equipment Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Custom Application",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Freight & Trucking",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Storage",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Utilities",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Irrigation",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Repairs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Fuel/Electricity",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hired Labor",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Interest (Operating)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,null,"lbs/ton",{"$f":"2000*(U55/100)","v":0},{"$f":"2000*(V55/100)","v":0}]
["Total Variable Costs",null,{"$f":"SUM(C19:C52)","v":0},null,null,{"$f":"SUM(F19:F52)","v":0},null,null,{"$f":"SUM(I19:I52)","v":0},null,null,{"$f":"SUM(L19:L52)","v":0},null,null,{"$f":"SUM(O19:O52)","v":0},null,null,{"$f":"SUM(R19:R52)","v":0},null,null,null,null,null,null,null,null,"%/ton",{"$f":"AB52/(AB52+AC52)","v":{"$error":"#DIV/0!"}},{"$f":"AC52/(AB52+AC52)","v":{"$error":"#DIV/0!"}}]
["Return Over Variable Costs ",null,{"$f":"C16-C53","v":0},null,null,{"$f":"F16-F53","v":0},null,null,{"$f":"I16-I53","v":0},null,null,{"$f":"L16-L53","v":0},null,null,{"$f":"O16-O53","v":0},null,null,{"$f":"R16-R53","v":0}]
["(Gross Revenue - Variable Costs)"]
["Fixed Costs"]
["Farm Insurance",null,0,{"$f":"C57","v":0},null,0,{"$f":"F57","v":0},null,0,{"$f":"I57","v":0},null,0,{"$f":"L57","v":0},null,0,{"$f":"O57","v":0},null,{"$f":"(C57*$C$11)+(F57*$F$11)+(I57*$I$11)+(L57*$L$11)+(O57*$O$11)","v":0}]
["Real Estate Taxes",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Land Rent",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Interest (Term)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Depreciation (Economic not Taxable)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Total Fixed Costs",null,{"$f":"SUM(C57:C62)","v":0},null,null,{"$f":"SUM(F57:F62)","v":0},null,null,{"$f":"SUM(I57:I62)","v":0},null,null,{"$f":"SUM(L57:L62)","v":0},null,null,{"$f":"SUM(O57:O62)","v":0},null,null,{"$f":"SUM(R57:R62)","v":0}]
["Total Variable & Fixed Costs",null,{"$f":"C53+C63","v":0},null,null,{"$f":"F53+F63","v":0},null,null,{"$f":"I53+I63","v":0},null,null,{"$f":"L53+L63","v":0},null,null,{"$f":"O53+O63","v":0},null,null,{"$f":"R53+R63","v":0}]
["Net Farm Income",null,{"$f":"C16-C64","v":0},null,null,{"$f":"F16-F64","v":0},null,null,{"$f":"I16-I64","v":0},null,null,{"$f":"L16-L64","v":0},null,null,{"$f":"O16-O64","v":0},null,null,{"$f":"R16-R64","v":0}]
["(Gross Revenue - Variable & Fixed Costs)"]
["Cash Flow"]
["Financing"]
["Income Taxes",null,0,{"$f":"C69","v":0},null,0,{"$f":"F69","v":0},null,0,{"$f":"I69","v":0},null,0,{"$f":"L69","v":0},null,0,{"$f":"O69","v":0},null,{"$f":"(C69*$C$11)+(F69*$F$11)+(I69*$I$11)+(L69*$L$11)+(O69*$O$11)","v":0}]
["Owner Withdrawal (Family Living)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Principal Payment",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Total Financing",null,{"$f":"SUM(C69:C71)","v":0},null,null,{"$f":"SUM(F69:F71)","v":0},null,null,{"$f":"SUM(I69:I71)","v":0},null,null,{"$f":"SUM(L69:L71)","v":0},null,null,{"$f":"SUM(O69:O71)","v":0},null,null,{"$f":"SUM(R69:R71)","v":0}]
["Total Variable, Fixed, and Financing",null,{"$f":"C72+C64","v":0},null,null,{"$f":"F72+F64","v":0},null,null,{"$f":"I72+I64","v":0},null,null,{"$f":"L72+L64","v":0},null,null,{"$f":"O72+O64","v":0},null,null,{"$f":"R72+R64","v":0}]
["Net Cash Flow",null,{"$f":"C16-C73+C61","v":0},null,null,{"$f":"F16-F73+F61","v":0},null,null,{"$f":"I16-I73+I61","v":0},null,null,{"$f":"L16-L73+L61","v":0},null,null,{"$f":"O16-O73+O61","v":0},null,null,{"$f":"R16-R73+R61","v":0}]
[" (Net Farm Income - Financing + Depreciation)"]
["Economic Profitability",null,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Economic Overhead",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Value of Unpaid Labor & Management",null,37.36,{"$f":"C78","v":37.36},null,40.4,{"$f":"F78","v":40.4},null,19.02,{"$f":"I78","v":19.02}]
["Value of Unpaid Equity Capital",null,0,0,null,0,0,null,0,0]
["Total Economic Overhead",null,{"$f":"SUM(C78:C79)","v":37.36},null,null,{"$f":"SUM(F78:F79)","v":40.4},null,null,{"$f":"SUM(I78:I79)","v":19.02}]
["Total Economic Cost of Production",null,{"$f":"C80+C73","v":37.36},null,null,{"$f":"F80+F73","v":40.4},null,null,{"$f":"I80+I73","v":19.02}]
["Economic Profit (Net Cash Flow - Unpaid Labor & Equity)",null,{"$f":"(C16-C81)+C61","v":-37.36},null,null,{"$f":"(F16-F81)+F61","v":-40.4},null,null,{"$f":"(I16-I81)+I61","v":-19.02}]
[]
["Financial Scorecard",null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["OPERATING EXPENSE RATIO",null,0,"80 - 100%",null,0,"80 - 100%",null,0,"80 - 100%",null,0,null,null,0]
[null,null,null,"60 - 80%",null,null,"60 - 80%",null,null,"60 - 80%"]
[null,null,null,"0 - 60%",null,null,"0 - 60%",null,null,"0 - 60%"]
[]
["DEPRECIATION EXPENSE RATIO",null,{"$f":"C61/C16","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"F61/F16","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"I61/I16","v":{"$error":"#DIV/0!"}},"10% - over"]
[null,null,null,"5 - 10%",null,null,"5 - 10%",null,null,"5 - 10%"]
[null,null,null,"0 - 5%",null,null,"0 - 5%",null,null,"0 - 5%"]
[]
["INTEREST EXPENSE RATIO",null,{"$f":"(C51+C60)/C16","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"(F51+F60)/F16","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"(I51+I60)/I16","v":{"$error":"#DIV/0!"}},"10% - over"]
[null,null,null,"5 - 10%",null,null,"5 - 10%",null,null,"5 - 10%"]
[null,null,null,"0 - 5%",null,null,"0 - 5%",null,null,"0 - 5%"]
[]
["NET FARM INCOME RATIO",null,{"$f":"C65/C16","v":{"$error":"#DIV/0!"}},"0 - 10%",null,{"$f":"F65/F16","v":{"$error":"#DIV/0!"}},"0 - 10%",null,{"$f":"I65/I16","v":{"$error":"#DIV/0!"}},"0 - 10%"]
[null,null,null,"10 - 20%",null,null,"10 - 20%",null,null,"10 - 20%"]
["*Note: these four ratios add up to 100%",null,null,"20% - over",null,null,"20% - over",null,null,"20% - over"]
[]
["Break-Even Calculations"]
["Net Returns (Variable & Fixed)"]
["Break-even $$/Unit",null,{"$f":"(C64-C61)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F64-F61)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I64-I61)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L64-L61)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O64-O61)/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Production/Unit ",null,{"$f":"(C64-C61)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F64-F61)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I64-I61)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L64-L61)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O64-O61)/O9","v":{"$error":"#DIV/0!"}}]
[]
["Repayment Capacity (Cash Flow)"]
["Break-even $$/Unit",null,{"$f":"(C73-C61)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F73-F61)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I73-I61)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L73-L61)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O73-O61)/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Production/Unit ",null,{"$f":"(C73-C61)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F73-F61)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I73-I61)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L73-L61)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O73-O61)/O9","v":{"$error":"#DIV/0!"}}]
[]
["Capital Retainment (Net Worth) Break-even"]
["Break-even $$/unit",null,{"$f":"(C64+C72)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F64+F72)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I64+I72)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L64+L72)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O64+O72)/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Yield/Acre ",null,{"$f":"(C64+C72)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F64+F72)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I64+I72)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L64+L72)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O64+O72)/O9","v":{"$error":"#DIV/0!"}}]
[]
["Economic (Profit) Break-even"]
["Break-even $$/Bushel",null,{"$f":"C81/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"F81/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I81/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L81/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O81/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Yield/Acre ",null,{"$f":"C81/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"F81/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I81/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L81/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O81/O9","v":{"$error":"#DIV/0!"}}]
[]
["FERTILITY PROGRAM"]
[]
["Nutrient Removal Rate",null,"N","P",null,"N","P",null,"N","P"]
["(Based on Yield Goal)",null,{"$f":"0.9*C10","v":0},{"$f":"0.37*C10","v":0},null,{"$f":"3.8*F10","v":0},{"$f":"0.8*F10","v":0},null,{"$f":"1.2*I10","v":0},{"$f":"0.63*I10","v":0}]
[null,null,"S","Ca",null,"S","Ca",null,"S","Ca"]
[null,null,{"$f":"0.08*C10","v":0},{"$f":"0.01*C10","v":0},null,{"$f":"0.18*F10","v":0},{"$f":"0.15*F10","v":0},null,{"$f":"0.1*I10","v":0},{"$f":"0.03*I10","v":0}]
[null,null,"Z","B",null,"Z","B",null,"Z","B"]
[null,null,{"$f":"(0.16/150)*$C$10","v":0},{"$f":"(0.36/150)*$C$10","v":0},null,{"$f":"(0.05/50)*$F$10","v":0},{"$f":"(0.06/50)*$F$10","v":0},null,{"$f":"(0.2/75)*$I$10","v":0},{"$f":"(0.06/75)*$I$10","v":0}]
[]
[]
["Cost Comparison Charts"]

{"sheet":"Cash Flow (Livestock)","index":2,"n_rows":128,"n_cols":32,"rows_kept":128,"cut":false,"hidden":false,"merged":[[6,19,7,25],[0,2,1,12],[4,2,4,3],[4,5,4,6],[4,8,4,9],[4,11,4,12],[4,14,4,15],[12,19,12,24],[13,19,13,24],[15,0,16,0],[15,1,16,1],[65,0,65,17],[82,0,82,9],[100,0,100,17],[117,0,117,9],[127,0,127,9],[0,14,0,17],[74,0,74,9],[5,2,5,3],[5,5,5,6],[5,8,5,9],[5,11,5,12],[5,14,5,15]]}
[null,null,"Cash Flow Estimator",null,null,null,null,null,null,null,null,null,null,null,"Farm Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":"Livestock 2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I5","v":"Livestock 3"}]
["(Enter Crop/Livestock Enterprise) -->",null,"Livestock 1",null,null,"Livestock 2",null,null,"Livestock 3",null,null,"Livestock 4",null,null,"Livestock 5",null,null,"Total Cash Flow",null,null,null,null,null,null,null,"Drop Down Menu"]
["(drop down menu) ->",null,"After Soybeans",null,null,"After Corn",null,null,"After Soybeans",null,null,"After Soybeans",null,null,"After Soybeans",null,null,null,null,null,null,null,null,null,null,"After Soybeans"]
["INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flow Estimator"]
["Gross Revenue"]
["Value Per Unit (i.e., cwt, ton)",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit"]
["Average Units (i.e., cwt, tons)",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,"Production Revenue"]
["Size of Enterprise (i.e., herd, litter)",null,0,"??",null,0,"??",null,0,"??",null,0,"??",null,0,"??",null,{"$f":"(C9*C10*C11)+(F9*F10*F11)+(I9*I10*I11)+(L9*L10*L11)+(O9*O10*O11)","v":0}]
[]
["Livestock Sales (i.e., cull sales)",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C13*$C$11)+(F13*$F$11)+(I13*$I$11)+(L13*$L$11)+(O13*$O$11)","v":0},null,"Prepared by: Jon LaPorte, Farm Business Management Educator"]
["Government Payments",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C14*$C$11)+(F14*$F$11)+(I14*$I$11)+(L14*$L$11)+(O14*$O$11)","v":0},null,"Suite 116, 120 N. Broadway, Cassopolis, MI 49031"]
["Other Income",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C15*$C$11)+(F15*$F$11)+(I15*$I$11)+(L15*$L$11)+(O15*$O$11)","v":0}]
["Gross Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise Totals"]
[null,null,{"$f":"(C9*C10)+C14+C15","v":0},null,null,{"$f":"(F9*F10)+F14+F15","v":0},null,null,{"$f":"(I9*I10)+I14+I15","v":0},null,null,{"$f":"(L10*L9)+L13+L14+L15","v":0},null,null,{"$f":"(O10*O9)+O13+O14+O15","v":0},null,null,{"$f":"SUM(R11,R13:R15)","v":0}]
["EXPENSE"]
["Variable Costs"]
["Purchased Livestock (i.e., calves)",null,0,{"$f":"C20","v":0},null,0,{"$f":"F20","v":0},null,0,{"$f":"I20","v":0},null,0,{"$f":"L20","v":0},null,0,{"$f":"O20","v":0},null,{"$f":"(C20*$C$11)+(F20*$F$11)+(I20*$I$11)+(L20*$L$11)+(O20*$O$11)","v":0}]
["Protein, Vitamins, Minerals",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Complete Ration",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C22*$C$11)+(F22*$F$11)+(I22*$I$11)+(L22*$L$11)+(O22*$O$11)","v":0}]
["Feed",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Corn",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C24*$C$11)+(F24*$F$11)+(I24*$I$11)+(L24*$L$11)+(O24*$O$11)","v":0}]
["Corn Silage",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hay, Alfalfa",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C26*$C$11)+(F26*$F$11)+(I26*$I$11)+(L26*$L$11)+(O26*$O$11)","v":0}]
["Hay, Grass",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Pasture",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hay, Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["DDGs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["DDGs, wet",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other Feed Stuffs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Veterinary",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Supplies",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Gas/Fuel",null,0,{"$f":"C35","v":0},null,0,{"$f":"F35","v":0},null,0,{"$f":"I35","v":0},null,0,{"$f":"L35","v":0},null,0,{"$f":"O35","v":0},null,{"$f":"(C35*$C$11)+(F35*$F$11)+(I35*$I$11)+(L35*$L$11)+(O35*$O$11)","v":0}]
["Repairs & Maintenance",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,null,null,null,null,null,null,null,null,null,"lbs/ton",{"$f":"2000*(U39/100)","v":0},{"$f":"2000*(V39/100)","v":0},null,{"$f":"SUM(AB36:AC36)","v":0}]
["Repair, Machinery",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,null,"%/ton",{"$f":"AB36/(AB36+AC36)","v":{"$error":"#DIV/0!"}},{"$f":"AC36/(AB36+AC36)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AB37:AC37)","v":{"$error":"#DIV/0!"}}]
["Repair, Buildings",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Custom Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Driver & Equipment Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Equipment Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Custom Application",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Freight & Trucking",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Storage",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Utilities",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Irrigation",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Repairs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Fuel/Electricity",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hired Labor",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Interest (Operating)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,null,"lbs/ton",{"$f":"2000*(U54/100)","v":0},{"$f":"2000*(V54/100)","v":0}]
["Total Variable Costs",null,{"$f":"SUM(C20:C51)","v":0},null,null,{"$f":"SUM(F20:F51)","v":0},null,null,{"$f":"SUM(I20:I51)","v":0},null,null,{"$f":"SUM(L20:L51)","v":0},null,null,{"$f":"SUM(O20:O51)","v":0},null,null,{"$f":"SUM(R20:R51)","v":0},null,null,null,null,null,null,null,null,"%/ton",{"$f":"AB51/(AB51+AC51)","v":{"$error":"#DIV/0!"}},{"$f":"AC51/(AB51+AC51)","v":{"$error":"#DIV/0!"}}]
["Return Over Variable Costs ",null,{"$f":"C17-C52","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["(Gross Revenue - Variable Costs)"]
["Fixed Costs"]
["Farm Insurance",null,0,{"$f":"C56","v":0},null,0,{"$f":"F56","v":0},null,0,{"$f":"I56","v":0},null,0,{"$f":"L56","v":0},null,0,{"$f":"O56","v":0},null,{"$f":"(C56*$C$11)+(F56*$F$11)+(I56*$I$11)+(L56*$L$11)+(O56*$O$11)","v":0}]
["Real Estate Taxes",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Land Rent",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Interest (Term)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Depreciation (Economic not Taxable)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Total Fixed Costs",null,{"$f":"SUM(C56:C61)","v":0},null,null,{"$f":"SUM(F56:F61)","v":0},null,null,{"$f":"SUM(I56:I61)","v":0},null,null,{"$f":"SUM(L56:L61)","v":0},null,null,{"$f":"SUM(O56:O61)","v":0},null,null,{"$f":"SUM(R56:R61)","v":0}]
["Total Variable & Fixed Costs",null,{"$f":"C62+C52","v":0},null,null,{"$f":"F62+F52","v":0},null,null,{"$f":"I62+I52","v":0},null,null,{"$f":"L62+L52","v":0},null,null,{"$f":"O62+O52","v":0},null,null,{"$f":"R62+R52","v":0}]
["Net Farm Income",null,{"$f":"C17-C63","v":0},null,null,{"$f":"F17-F63","v":0},null,null,{"$f":"I17-I63","v":0},null,null,{"$f":"L17-L63","v":0},null,null,{"$f":"O17-O63","v":0},null,null,{"$f":"R17-R63","v":0}]
["(Gross Revenue - Variable & Fixed Costs)"]
["Cash Flow"]
["Financing"]
["Income Taxes",null,0,{"$f":"C68","v":0},null,0,{"$f":"F68","v":0},null,0,{"$f":"I68","v":0},null,0,{"$f":"L68","v":0},null,0,{"$f":"O68","v":0},null,{"$f":"(C68*$C$11)+(F68*$F$11)+(I68*$I$11)+(L68*$L$11)+(O68*$O$11)","v":0}]
["Owner Withdrawal (Family Living)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Principal Payment",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Total Financing",null,{"$f":"SUM(C68:C70)","v":0},null,null,{"$f":"SUM(F68:F70)","v":0},null,null,{"$f":"SUM(I68:I70)","v":0},null,null,{"$f":"SUM(L68:L70)","v":0},null,null,{"$f":"SUM(O68:O70)","v":0},null,null,{"$f":"SUM(R68:R70)","v":0}]
["Total Variable, Fixed, and Financing",null,{"$f":"C71+C63","v":0},null,null,{"$f":"F71+F63","v":0},null,null,{"$f":"I71+I63","v":0},null,null,{"$f":"L71+L63","v":0},null,null,{"$f":"O71+O63","v":0},null,null,{"$f":"R71+R63","v":0}]
["Net Cash Flow",null,{"$f":"C17-C72+C60","v":0},null,null,{"$f":"F17-F72+F60","v":0},null,null,{"$f":"I17-I72+I60","v":0},null,null,{"$f":"L17-L72+L60","v":0},null,null,{"$f":"O17-O72+O60","v":0},null,null,{"$f":"(R17-R72)+R60","v":0}]
[" (Net Farm Income - Financing + Depreciation)"]
["Economic Profitability",null,null,null,null,null,null,null,null,null,null,0,null,null,0]
["Economic Overhead",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Value of Unpaid Labor & Management",null,0,{"$f":"C77","v":0},null,0,{"$f":"F77","v":0},null,0,{"$f":"I77","v":0},null,0,null,null,0]
["Value of Unpaid Equity Capital",null,0,0,null,0,0,null,0,0]
["Total Economic Overhead",null,{"$f":"SUM(C77:C78)","v":0},null,null,{"$f":"SUM(F77:F78)","v":0},null,null,{"$f":"SUM(I77:I78)","v":0}]
["Total Economic Cost of Production",null,{"$f":"C79+C72","v":0},null,null,{"$f":"F79+F72","v":0},null,null,{"$f":"I79+I72","v":0}]
["Economic Profit (Net Cash Flow - Unpaid Labor & Equity)",null,{"$f":"(C17-C80)+C60","v":0},null,null,{"$f":"(F17-F80)+F60","v":0},null,null,{"$f":"(I17-I80)+I60","v":0}]
[]
["Financial Scorecard"]
[null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["OPERATING EXPENSE RATIO",null,0,"80 - 100%",null,0,"80 - 100%",null,0,"80 - 100%",null,0,null,null,0]
[null,null,0,"60 - 80%",null,0,"60 - 80%",null,0,"60 - 80%",null,0,null,null,0]
[null,null,null,"0 - 60%",null,null,"0 - 60%",null,null,"0 - 60%"]
[]
["DEPRECIATION EXPENSE RATIO",null,{"$f":"C60/C17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"F60/F17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"I60/I17","v":{"$error":"#DIV/0!"}},"10% - over"]
[null,null,null,"5 - 10%",null,null,"5 - 10%",null,null,"5 - 10%"]
[null,null,null,"0 - 5%",null,null,"0 - 5%",null,null,"0 - 5%"]
[]
["INTEREST EXPENSE RATIO",null,{"$f":"(C50+C59)/C17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"(F50+F59)/F17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"(I50+I59)/I17","v":{"$error":"#DIV/0!"}},"10% - over"]
[null,null,null,"5 - 10%",null,null,"5 - 10%",null,null,"5 - 10%"]
[null,null,null,"0 - 5%",null,null,"0 - 5%",null,null,"0 - 5%"]
[]
["NET FARM INCOME RATIO",null,{"$f":"C64/C17","v":{"$error":"#DIV/0!"}},"0 - 10%",null,{"$f":"F64/F17","v":{"$error":"#DIV/0!"}},"0 - 10%",null,{"$f":"I64/I17","v":{"$error":"#DIV/0!"}},"0 - 10%"]
[null,null,null,"10 - 20%",null,null,"10 - 20%",null,null,"10 - 20%"]
["*Note: these four ratios add up to 100%",null,null,"20% - over",null,null,"20% - over",null,null,"20% - over"]
[]
["Break-Even Calculations"]
["Net Returns (Variable & Fixed)"]
["Break-even $$/Unit",null,{"$f":"(C63-C60)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F63-F60)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I63-I60)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L63-L60)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O63-O60)/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Production/Unit ",null,{"$f":"(C63-C60)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F63-F60)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I63-I60)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L63-L60)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O63-O60)/O9","v":{"$error":"#DIV/0!"}}]
[]
["Repayment Capacity (Cash Flow)"]
["Break-even $$/Unit",null,{"$f":"(C72-C60)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F72-F60)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I72-I60)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L72-L60)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O72-O60)/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Production/Unit ",null,{"$f":"(C72-C60)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F72-F60)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I72-I60)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L72-L60)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O72-O60)/O9","v":{"$error":"#DIV/0!"}}]
[]
["Capital Retainment (Net Worth) Break-even"]
["Break-even $$/unit",null,{"$f":"(C63+C71)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F63+F71)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I63+I71)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L63+L71)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O63+O71)/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Yield/Acre ",null,{"$f":"(C63+C71)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F63+F71)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I63+I71)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L63+L71)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O63+O71)/O9","v":{"$error":"#DIV/0!"}}]
[]
["Economic (Profit) Break-even"]
["Break-even $$/Bushel",null,{"$f":"C80/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"F80/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I80/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L80/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O80/O10","v":{"$error":"#DIV/0!"}}]
["Break-even Yield/Acre ",null,{"$f":"C80/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"F80/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I80/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L80/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O80/O9","v":{"$error":"#DIV/0!"}}]
[]
["FERTILITY PROGRAM"]
[]
["Nutrient Removal Rate",null,"N","P",null,"N","P",null,"N","P"]
["(Based on Yield Goal)",null,{"$f":"0.9*C10","v":0},{"$f":"0.37*C10","v":0},null,{"$f":"3.8*F10","v":0},{"$f":"0.8*F10","v":0},null,{"$f":"1.2*I10","v":0},{"$f":"0.63*I10","v":0}]
[null,null,"S","Ca",null,"S","Ca",null,"S","Ca"]
[null,null,{"$f":"0.08*C10","v":0},{"$f":"0.01*C10","v":0},null,{"$f":"0.18*F10","v":0},{"$f":"0.15*F10","v":0},null,{"$f":"0.1*I10","v":0},{"$f":"0.03*I10","v":0}]
[null,null,"Z","B",null,"Z","B",null,"Z","B"]
[null,null,{"$f":"(0.16/150)*$C$10","v":0},{"$f":"(0.36/150)*$C$10","v":0},null,{"$f":"(0.05/50)*$F$10","v":0},{"$f":"(0.06/50)*$F$10","v":0},null,{"$f":"(0.2/75)*$I$10","v":0},{"$f":"(0.06/75)*$I$10","v":0}]
[]
[]
["Cost Comparison Charts"]

{"sheet":"Cash Flow (Crops & Livestock)","index":3,"n_rows":144,"n_cols":35,"rows_kept":144,"cut":false,"hidden":false,"merged":[[143,0,143,9],[133,0,133,9],[15,0,16,0],[4,2,4,3],[4,5,4,6],[4,8,4,9],[5,2,5,3],[5,5,5,6],[5,8,5,9],[15,1,16,1],[90,0,90,9],[98,0,98,9],[0,2,1,12],[0,17,0,20],[4,11,4,12],[5,11,5,12],[4,14,4,15],[5,14,5,15],[116,0,116,20],[81,0,81,20],[12,22,12,27],[13,22,13,27],[4,17,4,18],[5,17,5,18],[6,22,7,28]]}
[null,null,"Cash Flow Estimator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farm Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":"Crop/Livestock 2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I5","v":"Crop/Livestock 3"}]
["(Enter Crop/Livestock Enterprise) -->",null,"Crop/Livestock 1",null,null,"Crop/Livestock 2",null,null,"Crop/Livestock 3",null,null,"Crop/Livestock 4",null,null,"Crop/Livestock 5",null,null,"Crop/Livestock 6",null,null,"Total Cash Flow",null,null,null,null,null,null,null,"Drop Down Menu"]
["(drop down menu) ->",null,"After Soybeans",null,null,"After Corn",null,null,"After Soybeans",null,null,"After Soybeans",null,null,"After Soybeans",null,null,"After Soybeans",null,null,null,null,null,null,null,null,null,null,"After Soybeans"]
["INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flow Estimator"]
["Gross Revenue"]
["Value Per Unit (i.e., bushel, cwt, ton)",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit",null,0,"Unit"]
["Average Units (i.e., bushels, cwt, tons)",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,0,"Units",null,"Production Revenue"]
["Size of Enterprise (i.e., herd, litter, acres)",null,0,"Acres",null,0,"Acres",null,0,"Acres",null,0,"??",null,0,"??",null,0,"??",null,{"$f":"(C9*C10*C11)+(F9*F10*F11)+(I9*I10*I11)+(L9*L10*L11)+(O9*O10*O11)+(R9*R10*R11)","v":0}]
[]
["Livestock Sales (i.e., cull sales)",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C13*$C$11)+(F13*$F$11)+(I13*$I$11)+(L13*$L$11)+(O13*$O$11)+(R13*$R$11)","v":0},null,"Prepared by: Jon LaPorte, Farm Business Management Educator"]
["Government Payments",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C14*$C$11)+(F14*$F$11)+(I14*$I$11)+(L14*$L$11)+(O14*$O$11)+(R14*$R$11)","v":0},null,"Suite 116, 120 N. Broadway, Cassopolis, MI 49031"]
["Other Income",null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(C15*$C$11)+(F15*$F$11)+(I15*$I$11)+(L15*$L$11)+(O15*$O$11)+(R15*$R$11)","v":0}]
["Gross Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise Totals"]
[null,null,{"$f":"(C9*C10)+C14+C15","v":0},null,null,{"$f":"(F9*F10)+F14+F15","v":0},null,null,{"$f":"(I9*I10)+I14+I15","v":0},null,null,{"$f":"(L10*L9)+L13+L14+L15","v":0},null,null,{"$f":"(O10*O9)+O13+O14+O15","v":0},null,null,{"$f":"(R10*R9)+R13+R14+R15","v":0},null,null,{"$f":"SUM(U11,U13:U15)","v":0}]
["EXPENSE"]
["Variable Costs"]
["Seed",null,0,{"$f":"C20","v":0},null,0,{"$f":"F20","v":0},null,0,{"$f":"I20","v":0},null,0,{"$f":"L20","v":0},null,0,{"$f":"O20","v":0},null,0,{"$f":"R20","v":0},null,{"$f":"(C20*$C$11)+(F20*$F$11)+(I20*$I$11)+(L20*$L$11)+(O20*$O$11)+(R20*$R$11)","v":0}]
["Fertilizer",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Nitrogen",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C22*$C$11)+(F22*$F$11)+(I22*$I$11)+(L22*$L$11)+(O22*$O$11)+(R22*$R$11)","v":0},null,null,null,null,null,null,null,{"$f":"2000*X22","v":0}]
["Phosphorus",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,{"$f":"2000*X27","v":0}]
["Potassium (Potash)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Sulfur",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Limestone",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other Fertilizer (i.e. micronutrients)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,{"$f":"2000*X23","v":0}]
["Crop Chemicals",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"2000*X28","v":0}]
["Herbicides",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C29*$C$11)+(F29*$F$11)+(I29*$I$11)+(L29*$L$11)+(O29*$O$11)+(R29*$R$11)","v":0},null,null,null,null,null,null,null,{"$f":"2000*X29","v":0}]
["Fungicides",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Insecticides",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Crop Insurance",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Crop Miscellaneous",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Purchased Livestock (i.e., calves)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Protein, Vitamins, Minerals",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Complete Ration",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Feed",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Corn",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C38*$C$11)+(F38*$F$11)+(I38*$I$11)+(L38*$L$11)+(O38*$O$11)+(R38*$R$11)","v":0}]
["Corn Silage",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hay, Alfalfa",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hay, Grass",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Pasture",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hay, Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["DDGs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["DDGs, wet",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other Feed Stuffs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Veterinary",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Supplies",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Gas/Fuel",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Equipment Fuel",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C50*$C$11)+(F50*$F$11)+(I50*$I$11)+(L50*$L$11)+(O50*$O$11)+(R50*$R$11)","v":0}]
["Drying Propane",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Repairs & Maintenance",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,"lbs/ton",{"$f":"2000*(X55/100)","v":0},{"$f":"2000*(Y55/100)","v":0},null,{"$f":"SUM(AE52:AF52)","v":0}]
["Repair, Machinery",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C53*$C$11)+(F53*$F$11)+(I53*$I$11)+(L53*$L$11)+(O53*$O$11)+(R53*$R$11)","v":0},null,null,null,null,null,null,null,null,"%/ton",{"$f":"AE52/(AE52+AF52)","v":{"$error":"#DIV/0!"}},{"$f":"AF52/(AE52+AF52)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AE53:AF53)","v":{"$error":"#DIV/0!"}}]
["Repair, Buildings",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Custom Hire",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Driver & Equipment Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C56*$C$11)+(F56*$F$11)+(I56*$I$11)+(L56*$L$11)+(O56*$O$11)+(R56*$R$11)","v":0}]
["Equipment Hire",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Custom Application",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Freight & Trucking",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Storage",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Utilities",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Irrigation",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Repairs",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C63*$C$11)+(F63*$F$11)+(I63*$I$11)+(L63*$L$11)+(O63*$O$11)+(R63*$R$11)","v":0}]
["Fuel/Electricity",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Hired Labor",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Interest (Operating)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,null,null,null,null,null,null,null,null,"lbs/ton",{"$f":"2000*(X70/100)","v":0},{"$f":"2000*(Y70/100)","v":0}]
["Total Variable Costs",null,{"$f":"SUM(C20:C67)","v":0},null,null,{"$f":"SUM(F20:F67)","v":0},null,null,{"$f":"SUM(I20:I67)","v":0},null,null,{"$f":"SUM(L20:L67)","v":0},null,null,{"$f":"SUM(O20:O67)","v":0},null,null,{"$f":"SUM(R20:R67)","v":0},null,null,{"$f":"SUM(U20:U67)","v":0},null,null,null,null,null,null,null,null,"%/ton",{"$f":"AE67/(AE67+AF67)","v":{"$error":"#DIV/0!"}},{"$f":"AF67/(AE67+AF67)","v":{"$error":"#DIV/0!"}}]
["Return Over Variable Costs ",null,{"$f":"C17-C68","v":0},null,null,{"$f":"F17-F68","v":0},null,null,{"$f":"I17-I68","v":0},null,null,{"$f":"L17-L68","v":0},null,null,{"$f":"O17-O68","v":0},null,null,{"$f":"R17-R68","v":0},null,null,{"$f":"U17-U68","v":0}]
["(Gross Revenue - Variable Costs)"]
["Fixed Costs"]
["Farm Insurance",null,0,{"$f":"C72","v":0},null,0,{"$f":"F72","v":0},null,0,{"$f":"I72","v":0},null,0,{"$f":"L72","v":0},null,0,{"$f":"O72","v":0},null,0,{"$f":"R72","v":0},null,{"$f":"(C72*$C$11)+(F72*$F$11)+(I72*$I$11)+(L72*$L$11)+(O72*$O$11)+(R72*$R$11)","v":0}]
["Real Estate Taxes",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Land Rent",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Interest (Term)",null,0,{"$f":"C75","v":0},null,0,{"$f":"F75","v":0},null,0,{"$f":"I75","v":0},null,0,0,null,0,0,null,0,0,null,0]
["Depreciation (Economic not Taxable)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Other",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Total Fixed Costs",null,{"$f":"SUM(C72:C77)","v":0},null,null,{"$f":"SUM(F72:F77)","v":0},null,null,{"$f":"SUM(I72:I77)","v":0},null,null,{"$f":"SUM(L72:L77)","v":0},null,null,{"$f":"SUM(O72:O77)","v":0},null,null,{"$f":"SUM(R72:R77)","v":0},null,null,{"$f":"SUM(U72:U77)","v":0}]
["Total Variable & Fixed Costs",null,{"$f":"C68+C78","v":0},null,null,{"$f":"F68+F78","v":0},null,null,{"$f":"I68+I78","v":0},null,null,{"$f":"L68+L78","v":0},null,null,{"$f":"O68+O78","v":0},null,null,{"$f":"R68+R78","v":0},null,null,{"$f":"U68+U78","v":0}]
["Net Farm Income",null,{"$f":"C17-C79","v":0},null,null,{"$f":"F17-F79","v":0},null,null,{"$f":"I17-I79","v":0},null,null,{"$f":"L17-L79","v":0},null,null,{"$f":"O17-O79","v":0},null,null,{"$f":"R17-R79","v":0},null,null,{"$f":"U17-U79","v":0}]
["(Gross Revenue - Variable & Fixed Costs)"]
["Cash Flow"]
["Financing"]
["Income Taxes",null,0,{"$f":"C84","v":0},null,0,{"$f":"F84","v":0},null,0,{"$f":"I84","v":0},null,0,{"$f":"L84","v":0},null,0,{"$f":"O84","v":0},null,0,{"$f":"R84","v":0},null,{"$f":"(C84*$C$11)+(F84*$F$11)+(I84*$I$11)+(L84*$L$11)+(O84*$O$11)+(R84*$R$11)","v":0}]
["Owner Withdrawal (Family Living)",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
["Principal Payment",null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"(C86*$C$11)+(F86*$F$11)+(I86*$I$11)+(L86*$L$11)+(O86*$O$11)+(R86*$R$11)","v":0}]
["Total Financing",null,{"$f":"SUM(C84:C86)","v":0},null,null,{"$f":"SUM(F84:F86)","v":0},null,null,{"$f":"SUM(I84:I86)","v":0},null,null,{"$f":"SUM(L84:L86)","v":0},null,null,{"$f":"SUM(O84:O86)","v":0},null,null,{"$f":"SUM(R84:R86)","v":0},null,null,{"$f":"SUM(U84:U86)","v":0}]
["Total Variable, Fixed, and Financing",null,{"$f":"C87+C79","v":0},null,null,{"$f":"F87+F79","v":0},null,null,{"$f":"I87+I79","v":0},null,null,{"$f":"L87+L79","v":0},null,null,{"$f":"O87+O79","v":0},null,null,{"$f":"R87+R79","v":0},null,null,{"$f":"U87+U79","v":0}]
["Net Cash Flow",null,{"$f":"(C17-C88)+C76","v":0},null,null,{"$f":"(F17-F88)+F76","v":0},null,null,{"$f":"(I17-I88)+I76","v":0},null,null,{"$f":"(L17-L88)+L76","v":0},null,null,{"$f":"(O17-O88)+O76","v":0},null,null,{"$f":"(R17-R88)+R76","v":0},null,null,{"$f":"(U17-U88)+U76","v":0}]
[" (Net Farm Income - Financing + Depreciation)"]
["Economic Profitability"]
["Economic Overhead",null,"Per Acre",null,null,"Per Acre",null,null,"Per Acre"]
["Value of Unpaid Labor & Management",null,37.36,{"$f":"C93","v":37.36},null,40.4,{"$f":"F93","v":40.4},null,19.02,{"$f":"I93","v":19.02}]
["Value of Unpaid Equity Capital",null,0,0,null,0,0,null,0,0]
["Total Economic Overhead",null,{"$f":"SUM(C93:C94)","v":37.36},null,null,{"$f":"SUM(F93:F94)","v":40.4},null,null,{"$f":"SUM(I93:I94)","v":19.02}]
["Total Economic Cost of Production",null,{"$f":"C95+C88","v":37.36},null,null,{"$f":"F95+F88","v":40.4},null,null,{"$f":"I95+I88","v":19.02}]
["Economic Profit (Net Cash Flow - Unpaid Labor & Equity)",null,{"$f":"(C17-C96)+C76","v":-37.36},null,null,{"$f":"(F17-F96)+F76","v":-40.4},null,null,{"$f":"(I17-I96)+I76","v":-19.02}]
[]
["Financial Scorecard"]
[]
["OPERATING EXPENSE RATIO",null,{"$f":"(C79-C66-C76-C75)/C17","v":{"$error":"#DIV/0!"}},"80 - 100%",null,{"$f":"(F79-F66-F76-F75)/F17","v":{"$error":"#DIV/0!"}},"80 - 100%",null,{"$f":"(I79-I66-I76-I75)/I17","v":{"$error":"#DIV/0!"}},"80 - 100%"]
[null,null,null,"60 - 80%",null,null,"60 - 80%",null,null,"60 - 80%"]
[null,null,null,"0 - 60%",null,null,"0 - 60%",null,null,"0 - 60%"]
[]
["DEPRECIATION EXPENSE RATIO",null,{"$f":"C76/C17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"F76/F17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"I76/I17","v":{"$error":"#DIV/0!"}},"10% - over"]
[null,null,null,"5 - 10%",null,null,"5 - 10%",null,null,"5 - 10%"]
[null,null,null,"0 - 5%",null,null,"0 - 5%",null,null,"0 - 5%"]
[]
["INTEREST EXPENSE RATIO",null,{"$f":"(C66+C75)/C17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"(F66+F75)/F17","v":{"$error":"#DIV/0!"}},"10% - over",null,{"$f":"(I66+I75)/I17","v":{"$error":"#DIV/0!"}},"10% - over"]
[null,null,null,"5 - 10%",null,null,"5 - 10%",null,null,"5 - 10%"]
[null,null,null,"0 - 5%",null,null,"0 - 5%",null,null,"0 - 5%"]
[]
["NET FARM INCOME RATIO",null,{"$f":"C80/C17","v":{"$error":"#DIV/0!"}},"0 - 10%",null,{"$f":"F80/F17","v":{"$error":"#DIV/0!"}},"0 - 10%",null,{"$f":"I80/I17","v":{"$error":"#DIV/0!"}},"0 - 10%"]
[null,null,null,"10 - 20%",null,null,"10 - 20%",null,null,"10 - 20%"]
["*Note: these four ratios add up to 100%",null,null,"20% - over",null,null,"20% - over",null,null,"20% - over"]
[]
["Break-Even Calculations"]
["Net Returns (Variable & Fixed)"]
["Break-even $$/Unit",null,{"$f":"(C79-C76)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F79-F76)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I79-I76)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L79-L76)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O79-O76)/O10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(R79-R76)/R10","v":{"$error":"#DIV/0!"}}]
["Break-even Production/Unit ",null,{"$f":"(C79-C76)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F79-F76)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I79-I76)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L79-L76)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O79-O76)/O9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(R79-R76)/R9","v":{"$error":"#DIV/0!"}}]
[]
["Repayment Capacity (Cash Flow)"]
["Break-even $$/Unit",null,{"$f":"(C88-C76)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F88-F76)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I88-I76)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L88-L76)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O88-O76)/O10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(R88-R76)/R10","v":{"$error":"#DIV/0!"}}]
["Break-even Production/Unit ",null,{"$f":"(C88-C76)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F88-F76)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I88-I76)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L88-L76)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O88-O76)/O9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(R88-R76)/R9","v":{"$error":"#DIV/0!"}}]
[]
["Capital Retainment (Net Worth) Break-even"]
["Break-even $$/unit",null,{"$f":"(C79+C87)/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F79+F87)/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I79+I87)/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L79+L87)/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O79+O87)/O10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(R79+R87)/R10","v":{"$error":"#DIV/0!"}}]
["Break-even Yield/Acre ",null,{"$f":"(C79+C87)/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(F79+F87)/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I79+I87)/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(L79+L87)/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O79+O87)/O9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(R79+R87)/R9","v":{"$error":"#DIV/0!"}}]
[]
["Economic (Profit) Break-even"]
["Break-even $$/Bushel",null,{"$f":"C96/C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"F96/F10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I96/I10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L96/L10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O96/O10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R96/R10","v":{"$error":"#DIV/0!"}}]
["Break-even Yield/Acre ",null,{"$f":"C96/C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"F96/F9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I96/I9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L96/L9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"O96/O9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R96/R9","v":{"$error":"#DIV/0!"}}]
[]
["FERTILITY PROGRAM"]
[]
["Nutrient Removal Rate",null,"N","P",null,"N","P",null,"N","P"]
["(Based on Yield Goal)",null,{"$f":"0.9*C10","v":0},{"$f":"0.37*C10","v":0},null,{"$f":"3.8*F10","v":0},{"$f":"0.8*F10","v":0},null,{"$f":"1.2*I10","v":0},{"$f":"0.63*I10","v":0}]
[null,null,"S","Ca",null,"S","Ca",null,"S","Ca"]
[null,null,{"$f":"0.08*C10","v":0},{"$f":"0.01*C10","v":0},null,{"$f":"0.18*F10","v":0},{"$f":"0.15*F10","v":0},null,{"$f":"0.1*I10","v":0},{"$f":"0.03*I10","v":0}]
[null,null,"Z","B",null,"Z","B",null,"Z","B"]
[null,null,{"$f":"(0.16/150)*$C$10","v":0},{"$f":"(0.36/150)*$C$10","v":0},null,{"$f":"(0.05/50)*$F$10","v":0},{"$f":"(0.06/50)*$F$10","v":0},null,{"$f":"(0.2/75)*$I$10","v":0},{"$f":"(0.06/75)*$I$10","v":0}]
[]
[]
["Cost Comparison Charts"]

{"sheet":"Printable (Crops)","index":4,"n_rows":129,"n_cols":5,"rows_kept":129,"cut":false,"hidden":false,"merged":[[66,0,66,2],[6,4,7,6],[0,0,1,2],[11,4,11,6],[14,0,15,0],[14,1,15,1],[75,0,75,1],[83,0,83,1],[101,0,101,2],[118,0,118,1],[128,0,128,1]]}
[{"$f":"'Cash Flow (Crops)'!O1","v":"Farm Name"}]
[]
[]
[]
[null,null,"Total Cash Flow"]
["(drop down menu) ->"]
["INCOME",null,null,null,"Cash Flow Estimator"]
["Gross Revenue"]
[]
[]
["Production Revenue",null,{"$f":"'Cash Flow (Crops)'!R11","v":0}]
[]
["Government Payments",null,{"$f":"'Cash Flow (Crops)'!R13","v":0}]
["Other Income",null,{"$f":"'Cash Flow (Crops)'!R14","v":0}]
["Gross Revenue",null,"Enterprise Totals"]
[null,null,{"$f":"SUM(C11,C13:C14)","v":0}]
["EXPENSE"]
["Variable Costs"]
["Seed",null,{"$f":"'Cash Flow (Crops)'!R19","v":0}]
["Fertilizer",null,{"$f":"'Cash Flow (Crops)'!R20","v":0}]
["Nitrogen",null,{"$f":"'Cash Flow (Crops)'!R21","v":0}]
["Phosphorus",null,{"$f":"'Cash Flow (Crops)'!R22","v":0}]
["Potassium (Potash)",null,{"$f":"'Cash Flow (Crops)'!R23","v":0}]
["Sulfur",null,{"$f":"'Cash Flow (Crops)'!R24","v":0}]
["Limestone",null,{"$f":"'Cash Flow (Crops)'!R25","v":0}]
["Other Fertilizer (i.e. micronutrients)",null,{"$f":"'Cash Flow (Crops)'!R26","v":0}]
["Crop Chemicals",null,{"$f":"'Cash Flow (Crops)'!R27","v":0}]
["Herbicides",null,{"$f":"'Cash Flow (Crops)'!R28","v":0}]
["Fungicides",null,{"$f":"'Cash Flow (Crops)'!R29","v":0}]
["Insecticides",null,{"$f":"'Cash Flow (Crops)'!R30","v":0}]
["Crop Insurance",null,{"$f":"'Cash Flow (Crops)'!R31","v":0}]
["Crop Miscellaneous",null,{"$f":"'Cash Flow (Crops)'!R32","v":0}]
["Supplies",null,{"$f":"'Cash Flow (Crops)'!R33","v":0}]
["Gas/Fuel",null,{"$f":"'Cash Flow (Crops)'!R34","v":0}]
["Equipment Fuel",null,{"$f":"'Cash Flow (Crops)'!R35","v":0}]
["Drying Propane",null,{"$f":"'Cash Flow (Crops)'!R36","v":0}]
["Repairs & Maintenance",null,{"$f":"'Cash Flow (Crops)'!R37","v":0}]
["Repair, Machinery",null,{"$f":"'Cash Flow (Crops)'!R38","v":0}]
["Repair, Buildings",null,{"$f":"'Cash Flow (Crops)'!R39","v":0}]
["Custom Hire",null,{"$f":"'Cash Flow (Crops)'!R40","v":0}]
["Driver & Equipment Hire",null,{"$f":"'Cash Flow (Crops)'!R41","v":0}]
["Equipment Hire",null,{"$f":"'Cash Flow (Crops)'!R42","v":0}]
["Custom Application",null,{"$f":"'Cash Flow (Crops)'!R43","v":0}]
["Freight & Trucking",null,{"$f":"'Cash Flow (Crops)'!R44","v":0}]
["Storage",null,{"$f":"'Cash Flow (Crops)'!R45","v":0}]
["Utilities",null,{"$f":"'Cash Flow (Crops)'!R46","v":0}]
["Irrigation",null,{"$f":"'Cash Flow (Crops)'!R47","v":0}]
["Repairs",null,{"$f":"'Cash Flow (Crops)'!R48","v":0}]
["Fuel/Electricity",null,{"$f":"'Cash Flow (Crops)'!R49","v":0}]
["Hired Labor",null,{"$f":"'Cash Flow (Crops)'!R50","v":0}]
["Interest (Operating)",null,{"$f":"'Cash Flow (Crops)'!R51","v":0}]
["Other",null,{"$f":"'Cash Flow (Crops)'!R52","v":0}]
["Total Variable Costs",null,{"$f":"SUM(C19:C52)","v":0}]
["Return Over Variable Costs ",null,{"$f":"C16-C53","v":0}]
["(Gross Revenue - Variable Costs)"]
["Fixed Costs"]
["Farm Insurance",null,{"$f":"'Cash Flow (Crops)'!R57","v":0}]
["Real Estate Taxes",null,{"$f":"'Cash Flow (Crops)'!R58","v":0}]
["Land Rent",null,{"$f":"'Cash Flow (Crops)'!R59","v":0}]
["Interest (Term)",null,{"$f":"'Cash Flow (Crops)'!R60","v":0}]
["Depreciation (Economic not Taxable)",null,{"$f":"'Cash Flow (Crops)'!R61","v":0}]
["Other",null,{"$f":"'Cash Flow (Crops)'!R62","v":0}]
["Total Fixed Costs",null,{"$f":"SUM(C57:C62)","v":0}]
["Total Variable & Fixed Costs",null,{"$f":"C53+C63","v":0}]
["Net Farm Income",null,{"$f":"C16-C64","v":0}]
["(Gross Revenue - Variable & Fixed Costs)"]
["Cash Flow"]
["Financing"]
["Income Taxes",null,{"$f":"'Cash Flow (Crops)'!R69","v":0}]
["Owner Withdrawal (Family Living)",null,{"$f":"'Cash Flow (Crops)'!R70","v":0}]
["Principal Payment",null,{"$f":"'Cash Flow (Crops)'!R71","v":0}]
["Total Financing",null,{"$f":"SUM(C69:C71)","v":0}]
["Total Variable, Fixed, and Financing",null,{"$f":"C72+C64","v":0}]
["Net Cash Flow",null,{"$f":"(C16-C73)+C61","v":0}]
[" (Net Farm Income - Financing + Depreciation)"]
["Economic Profitability"]
["Economic Overhead"]
["Value of Unpaid Labor & Management"]
["Value of Unpaid Equity Capital"]
["Total Economic Overhead"]
["Total Economic Cost of Production"]
["Economic Profit (Net Cash Flow - Unpaid Labor & Equity)"]
[]
["Financial Scorecard"]
[]
["OPERATING EXPENSE RATIO"]
[]
[]
[]
["DEPRECIATION EXPENSE RATIO"]
[]
[]
[]
["INTEREST EXPENSE RATIO"]
[]
[]
[]
["NET FARM INCOME RATIO"]
[]
["*Note: these four ratios add up to 100%"]
[]
["Break-Even Calculations"]
["Net Returns (Variable & Fixed)"]
["Break-even $$/Unit"]
["Break-even Production/Unit "]
[]
["Repayment Capacity (Cash Flow)"]
["Break-even $$/Unit"]
["Break-even Production/Unit "]
[]
["Capital Retainment (Net Worth) Break-even"]
["Break-even $$/unit"]
["Break-even Yield/Acre "]
[]
["Economic (Profit) Break-even"]
["Break-even $$/Bushel"]
["Break-even Yield/Acre "]
[]
["FERTILITY PROGRAM"]
[]
["Nutrient Removal Rate"]
["(Based on Yield Goal)"]
[]
[]
[]
[]
[]
[]
["Cost Comparison Charts"]

{"sheet":"Printable (Livestock)","index":5,"n_rows":128,"n_cols":5,"rows_kept":128,"cut":false,"hidden":false,"merged":[[65,0,65,2],[6,4,7,6],[11,4,11,6],[0,0,1,2],[15,0,16,0],[15,1,16,1],[74,0,74,1],[82,0,82,1],[100,0,100,2],[117,0,117,1],[127,0,127,1]]}
[{"$f":"'Cash Flow (Livestock)'!O1","v":"Farm Name"}]
[]
[]
[]
[null,null,"Total Cash Flow"]
["(drop down menu) ->"]
["INCOME",null,null,null,"Cash Flow Estimator"]
["Gross Revenue"]
[]
[]
["Production Revenue",null,{"$f":"'Cash Flow (Livestock)'!R11","v":0}]
[]
["Livestock Sales (i.e., cull sales)",null,{"$f":"'Cash Flow (Livestock)'!R13","v":0}]
["Government Payments",null,{"$f":"'Cash Flow (Livestock)'!R14","v":0}]
["Other Income",null,{"$f":"'Cash Flow (Livestock)'!R15","v":0}]
["Gross Revenue",null,"Enterprise Totals"]
[null,null,{"$f":"SUM(C11,C13:C15)","v":0}]
["EXPENSE"]
["Variable Costs"]
["Purchased Livestock (i.e., calves)",null,{"$f":"'Cash Flow (Livestock)'!R20","v":0}]
["Protein, Vitamins, Minerals",null,{"$f":"'Cash Flow (Livestock)'!R21","v":0}]
["Complete Ration",null,{"$f":"'Cash Flow (Livestock)'!R22","v":0}]
["Feed",null,{"$f":"'Cash Flow (Livestock)'!R23","v":0}]
["Corn",null,{"$f":"'Cash Flow (Livestock)'!R24","v":0}]
["Corn Silage",null,{"$f":"'Cash Flow (Livestock)'!R25","v":0}]
["Hay, Alfalfa",null,{"$f":"'Cash Flow (Livestock)'!R26","v":0}]
["Hay, Grass",null,{"$f":"'Cash Flow (Livestock)'!R27","v":0}]
["Pasture",null,{"$f":"'Cash Flow (Livestock)'!R28","v":0}]
["Hay, Other",null,{"$f":"'Cash Flow (Livestock)'!R29","v":0}]
["DDGs",null,{"$f":"'Cash Flow (Livestock)'!R30","v":0}]
["DDGs, wet",null,{"$f":"'Cash Flow (Livestock)'!R31","v":0}]
["Other Feed Stuffs",null,{"$f":"'Cash Flow (Livestock)'!R32","v":0}]
["Veterinary",null,{"$f":"'Cash Flow (Livestock)'!R33","v":0}]
["Supplies",null,{"$f":"'Cash Flow (Livestock)'!R34","v":0}]
["Gas/Fuel",null,{"$f":"'Cash Flow (Livestock)'!R35","v":0}]
["Repairs & Maintenance",null,{"$f":"'Cash Flow (Livestock)'!R36","v":0}]
["Repair, Machinery",null,{"$f":"'Cash Flow (Livestock)'!R37","v":0}]
["Repair, Buildings",null,{"$f":"'Cash Flow (Livestock)'!R38","v":0}]
["Custom Hire",null,{"$f":"'Cash Flow (Livestock)'!R39","v":0}]
["Driver & Equipment Hire",null,{"$f":"'Cash Flow (Livestock)'!R40","v":0}]
["Equipment Hire",null,{"$f":"'Cash Flow (Livestock)'!R41","v":0}]
["Custom Application",null,{"$f":"'Cash Flow (Livestock)'!R42","v":0}]
["Freight & Trucking",null,{"$f":"'Cash Flow (Livestock)'!R43","v":0}]
["Storage",null,{"$f":"'Cash Flow (Livestock)'!R44","v":0}]
["Utilities",null,{"$f":"'Cash Flow (Livestock)'!R45","v":0}]
["Irrigation",null,{"$f":"'Cash Flow (Livestock)'!R46","v":0}]
["Repairs",null,{"$f":"'Cash Flow (Livestock)'!R47","v":0}]
["Fuel/Electricity",null,{"$f":"'Cash Flow (Livestock)'!R48","v":0}]
["Hired Labor",null,{"$f":"'Cash Flow (Livestock)'!R49","v":0}]
["Interest (Operating)",null,{"$f":"'Cash Flow (Livestock)'!R50","v":0}]
["Other",null,{"$f":"'Cash Flow (Livestock)'!R51","v":0}]
["Total Variable Costs",null,{"$f":"SUM(C20:C51)","v":0}]
["Return Over Variable Costs ",null,{"$f":"C17-C52","v":0}]
["(Gross Revenue - Variable Costs)"]
["Fixed Costs"]
["Farm Insurance",null,{"$f":"'Cash Flow (Livestock)'!R56","v":0}]
["Real Estate Taxes",null,{"$f":"'Cash Flow (Livestock)'!R57","v":0}]
["Land Rent",null,{"$f":"'Cash Flow (Livestock)'!R58","v":0}]
["Interest (Term)",null,{"$f":"'Cash Flow (Livestock)'!R59","v":0}]
["Depreciation (Economic not Taxable)",null,{"$f":"'Cash Flow (Livestock)'!R60","v":0}]
["Other",null,{"$f":"'Cash Flow (Livestock)'!R61","v":0}]
["Total Fixed Costs",null,{"$f":"SUM(C56:C61)","v":0}]
["Total Variable & Fixed Costs",null,{"$f":"C52+C62","v":0}]
["Net Farm Income",null,{"$f":"C17-C63","v":0}]
["(Gross Revenue - Variable & Fixed Costs)"]
["Cash Flow"]
["Financing"]
["Income Taxes",null,{"$f":"'Cash Flow (Livestock)'!R68","v":0}]
["Owner Withdrawal (Family Living)",null,{"$f":"'Cash Flow (Livestock)'!R69","v":0}]
["Principal Payment",null,{"$f":"'Cash Flow (Livestock)'!R70","v":0}]
["Total Financing",null,{"$f":"SUM(C68:C70)","v":0}]
["Total Variable, Fixed, and Financing",null,{"$f":"C71+C63","v":0}]
["Net Cash Flow",null,{"$f":"(C17-C72)+C60","v":0}]
[" (Net Farm Income - Financing + Depreciation)"]
["Economic Profitability"]
["Economic Overhead"]
["Value of Unpaid Labor & Management"]
["Value of Unpaid Equity Capital"]
["Total Economic Overhead"]
["Total Economic Cost of Production"]
["Economic Profit (Net Cash Flow - Unpaid Labor & Equity)"]
[]
["Financial Scorecard"]
[]
["OPERATING EXPENSE RATIO"]
[]
[]
[]
["DEPRECIATION EXPENSE RATIO"]
[]
[]
[]
["INTEREST EXPENSE RATIO"]
[]
[]
[]
["NET FARM INCOME RATIO"]
[]
["*Note: these four ratios add up to 100%"]
[]
["Break-Even Calculations"]
["Net Returns (Variable & Fixed)"]
["Break-even $$/Unit"]
["Break-even Production/Unit "]
[]
["Repayment Capacity (Cash Flow)"]
["Break-even $$/Unit"]
["Break-even Production/Unit "]
[]
["Capital Retainment (Net Worth) Break-even"]
["Break-even $$/unit"]
["Break-even Yield/Acre "]
[]
["Economic (Profit) Break-even"]
["Break-even $$/Bushel"]
["Break-even Yield/Acre "]
[]
["FERTILITY PROGRAM"]
[]
["Nutrient Removal Rate"]
["(Based on Yield Goal)"]
[]
[]
[]
[]
[]
[]
["Cost Comparison Charts"]

{"sheet":"Printable (Crops & Livestock)","index":6,"n_rows":144,"n_cols":5,"rows_kept":144,"cut":false,"hidden":false,"merged":[[6,4,7,6],[11,4,11,6],[15,0,16,0],[15,1,16,1],[81,0,81,2],[90,0,90,1],[98,0,98,1],[116,0,116,2],[133,0,133,1],[143,0,143,1],[0,0,1,2]]}
[{"$f":"'Cash Flow (Crops & Livestock)'!R1","v":"Farm Name"}]
[]
[]
[]
[null,null,"Total Cash Flow"]
["(drop down menu) ->"]
["INCOME",null,null,null,"Cash Flow Estimator"]
["Gross Revenue"]
[]
[]
["Production Revenue",null,{"$f":"'Cash Flow (Crops & Livestock)'!U11","v":0}]
[]
["Livestock Sales (i.e., cull sales)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U13","v":0}]
["Government Payments",null,{"$f":"'Cash Flow (Crops & Livestock)'!U14","v":0}]
["Other Income",null,{"$f":"'Cash Flow (Crops & Livestock)'!U15","v":0}]
["Gross Revenue",null,"Enterprise Totals"]
[null,null,{"$f":"SUM(C11,C13:C15)","v":0}]
["EXPENSE"]
["Variable Costs"]
["Seed",null,{"$f":"'Cash Flow (Crops & Livestock)'!U20","v":0}]
["Fertilizer"]
["Nitrogen",null,{"$f":"'Cash Flow (Crops & Livestock)'!U22","v":0}]
["Phosphorus",null,{"$f":"'Cash Flow (Crops & Livestock)'!U23","v":0}]
["Potassium (Potash)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U24","v":0}]
["Sulfur",null,{"$f":"'Cash Flow (Crops & Livestock)'!U25","v":0}]
["Limestone",null,{"$f":"'Cash Flow (Crops & Livestock)'!U26","v":0}]
["Other Fertilizer (i.e. micronutrients)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U27","v":0}]
["Crop Chemicals",null,{"$f":"'Cash Flow (Crops & Livestock)'!U28","v":0}]
["Herbicides",null,{"$f":"'Cash Flow (Crops & Livestock)'!U29","v":0}]
["Fungicides",null,{"$f":"'Cash Flow (Crops & Livestock)'!U30","v":0}]
["Insecticides",null,{"$f":"'Cash Flow (Crops & Livestock)'!U31","v":0}]
["Crop Insurance",null,{"$f":"'Cash Flow (Crops & Livestock)'!U32","v":0}]
["Crop Miscellaneous",null,{"$f":"'Cash Flow (Crops & Livestock)'!U33","v":0}]
["Purchased Livestock (i.e., calves)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U34","v":0}]
["Protein, Vitamins, Minerals",null,{"$f":"'Cash Flow (Crops & Livestock)'!U35","v":0}]
["Complete Ration",null,{"$f":"'Cash Flow (Crops & Livestock)'!U36","v":0}]
["Feed"]
["Corn",null,{"$f":"'Cash Flow (Crops & Livestock)'!U38","v":0}]
["Corn Silage",null,{"$f":"'Cash Flow (Crops & Livestock)'!U39","v":0}]
["Hay, Alfalfa",null,{"$f":"'Cash Flow (Crops & Livestock)'!U40","v":0}]
["Hay, Grass",null,{"$f":"'Cash Flow (Crops & Livestock)'!U41","v":0}]
["Pasture",null,{"$f":"'Cash Flow (Crops & Livestock)'!U42","v":0}]
["Hay, Other",null,{"$f":"'Cash Flow (Crops & Livestock)'!U43","v":0}]
["DDGs",null,{"$f":"'Cash Flow (Crops & Livestock)'!U44","v":0}]
["DDGs, wet",null,{"$f":"'Cash Flow (Crops & Livestock)'!U45","v":0}]
["Other Feed Stuffs",null,{"$f":"'Cash Flow (Crops & Livestock)'!U46","v":0}]
["Veterinary",null,{"$f":"'Cash Flow (Crops & Livestock)'!U47","v":0}]
["Supplies",null,{"$f":"'Cash Flow (Crops & Livestock)'!U48","v":0}]
["Gas/Fuel"]
["Equipment Fuel",null,{"$f":"'Cash Flow (Crops & Livestock)'!U50","v":0}]
["Drying Propane",null,{"$f":"'Cash Flow (Crops & Livestock)'!U51","v":0}]
["Repairs & Maintenance"]
["Repair, Machinery",null,{"$f":"'Cash Flow (Crops & Livestock)'!U53","v":0}]
["Repair, Buildings",null,{"$f":"'Cash Flow (Crops & Livestock)'!U54","v":0}]
["Custom Hire"]
["Driver & Equipment Hire",null,{"$f":"'Cash Flow (Crops & Livestock)'!U56","v":0}]
["Equipment Hire",null,{"$f":"'Cash Flow (Crops & Livestock)'!U57","v":0}]
["Custom Application",null,{"$f":"'Cash Flow (Crops & Livestock)'!U58","v":0}]
["Freight & Trucking",null,{"$f":"'Cash Flow (Crops & Livestock)'!U59","v":0}]
["Storage",null,{"$f":"'Cash Flow (Crops & Livestock)'!U60","v":0}]
["Utilities",null,{"$f":"'Cash Flow (Crops & Livestock)'!U61","v":0}]
["Irrigation"]
["Repairs",null,{"$f":"'Cash Flow (Crops & Livestock)'!U63","v":0}]
["Fuel/Electricity",null,{"$f":"'Cash Flow (Crops & Livestock)'!U64","v":0}]
["Hired Labor",null,{"$f":"'Cash Flow (Crops & Livestock)'!U65","v":0}]
["Interest (Operating)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U66","v":0}]
["Other",null,{"$f":"'Cash Flow (Crops & Livestock)'!U67","v":0}]
["Total Variable Costs",null,{"$f":"SUM(C20:C67)","v":0}]
["Return Over Variable Costs ",null,{"$f":"C17-C68","v":0}]
["(Gross Revenue - Variable Costs)"]
["Fixed Costs"]
["Farm Insurance",null,{"$f":"'Cash Flow (Crops & Livestock)'!U72","v":0}]
["Real Estate Taxes",null,{"$f":"'Cash Flow (Crops & Livestock)'!U73","v":0}]
["Land Rent",null,{"$f":"'Cash Flow (Crops & Livestock)'!U74","v":0}]
["Interest (Term)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U75","v":0}]
["Depreciation (Economic not Taxable)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U76","v":0}]
["Other",null,{"$f":"'Cash Flow (Crops & Livestock)'!U77","v":0}]
["Total Fixed Costs",null,{"$f":"SUM(C72:C77)","v":0}]
["Total Variable & Fixed Costs",null,{"$f":"C68+C78","v":0}]
["Net Farm Income",null,{"$f":"C17-C79","v":0}]
["(Gross Revenue - Variable & Fixed Costs)"]
["Cash Flow"]
["Financing"]
["Income Taxes",null,{"$f":"'Cash Flow (Crops & Livestock)'!U84","v":0}]
["Owner Withdrawal (Family Living)",null,{"$f":"'Cash Flow (Crops & Livestock)'!U85","v":0}]
["Principal Payment",null,{"$f":"'Cash Flow (Crops & Livestock)'!U86","v":0}]
["Total Financing",null,{"$f":"SUM(C84:C86)","v":0}]
["Total Variable, Fixed, and Financing",null,{"$f":"C87+C79","v":0}]
["Net Cash Flow",null,{"$f":"(C17-C88)+C76","v":0}]
[" (Net Farm Income - Financing + Depreciation)"]
["Economic Profitability"]
["Economic Overhead"]
["Value of Unpaid Labor & Management"]
["Value of Unpaid Equity Capital"]
["Total Economic Overhead"]
["Total Economic Cost of Production"]
["Economic Profit (Net Cash Flow - Unpaid Labor & Equity)"]
[]
["Financial Scorecard"]
[]
["OPERATING EXPENSE RATIO"]
[]
[]
[]
["DEPRECIATION EXPENSE RATIO"]
[]
[]
[]
["INTEREST EXPENSE RATIO"]
[]
[]
[]
["NET FARM INCOME RATIO"]
[]
["*Note: these four ratios add up to 100%"]
[]
["Break-Even Calculations"]
["Net Returns (Variable & Fixed)"]
["Break-even $$/Unit"]
["Break-even Production/Unit "]
[]
["Repayment Capacity (Cash Flow)"]
["Break-even $$/Unit"]
["Break-even Production/Unit "]
[]
["Capital Retainment (Net Worth) Break-even"]
["Break-even $$/unit"]
["Break-even Yield/Acre "]
[]
["Economic (Profit) Break-even"]
["Break-even $$/Bushel"]
["Break-even Yield/Acre "]
[]
["FERTILITY PROGRAM"]
[]
["Nutrient Removal Rate"]
["(Based on Yield Goal)"]
[]
[]
[]
[]
[]
[]
["Cost Comparison Charts"]

{"sheet":"Chart Drivers","index":7,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[null,"Corn","Soybeans","Wheat",null,null,null,null,null,"Corn","Soybeans","Wheat"]
["Seed",{"$f":"'Cash Flow (Crops & Livestock)'!C20","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F20","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I20","v":0},null,null,null,null,"Variable",{"$f":"'Cash Flow (Crops & Livestock)'!C68","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F68","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I68","v":0}]
["Fertilizer",{"$f":"SUM(B4:B7)","v":0},{"$f":"SUM(C4:C7)","v":0},{"$f":"SUM(D4:D7)","v":0},null,null,null,null,"Fixed",{"$f":"'Cash Flow (Crops & Livestock)'!C78","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F78","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I78","v":0}]
["Nitrogen",{"$f":"'Cash Flow (Crops & Livestock)'!C22","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F22","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I22","v":0},null,null,null,null,"Variable & Fixed",{"$f":"'Cash Flow (Crops & Livestock)'!C79","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F79","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I79","v":0}]
["Phosphorus",{"$f":"'Cash Flow (Crops & Livestock)'!C23","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F23","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I23","v":0}]
["Potassium (Potash)",{"$f":"'Cash Flow (Crops & Livestock)'!C24","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F24","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I24","v":0}]
["Limestone",{"$f":"'Cash Flow (Crops & Livestock)'!C27","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F27","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I27","v":0}]
["Crop Chemicals",{"$f":"SUM(B9:B11)","v":0},{"$f":"SUM(C9:C11)","v":0},{"$f":"SUM(D9:D11)","v":0},null,null,null,null,"Variable & Fixed",{"$f":"SUM(J2:J3)","v":0},{"$f":"SUM(K2:K3)","v":0},{"$f":"SUM(L2:L3)","v":0}]
["Herbicides",{"$f":"'Cash Flow (Crops & Livestock)'!C29","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F29","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I29","v":0}]
["Fungicides",{"$f":"'Cash Flow (Crops & Livestock)'!C30","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F30","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I30","v":0}]
["Insecticides",{"$f":"'Cash Flow (Crops & Livestock)'!C31","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F31","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I31","v":0}]
["Crop Insurance",{"$f":"'Cash Flow (Crops & Livestock)'!C32","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F32","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I32","v":0}]
["Crop Miscellaneous",{"$f":"'Cash Flow (Crops & Livestock)'!C33","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F33","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I33","v":0}]
["Supplies",{"$f":"'Cash Flow (Crops & Livestock)'!C48","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F48","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I48","v":0}]
["Gas/Fuel",{"$f":"SUM(B16:B17)","v":0},{"$f":"SUM(C16:C17)","v":0},0]
["Equipment Fuel",{"$f":"'Cash Flow (Crops & Livestock)'!C50","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F50","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I50","v":0}]
["Drying Propane",{"$f":"'Cash Flow (Crops & Livestock)'!C51","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F51","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I51","v":0}]
["Repairs & Maintenance",{"$f":"SUM(B19:B20)","v":0},{"$f":"SUM(C19:C20)","v":0},0]
["Repair, Machinery",{"$f":"'Cash Flow (Crops & Livestock)'!C53","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F53","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I53","v":0}]
["Repair, Buildings",{"$f":"'Cash Flow (Crops & Livestock)'!C54","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F54","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I54","v":0}]
["Custom Hire",{"$f":"SUM(B22:B24)","v":0},{"$f":"SUM(C22:C24)","v":0},0]
["Driver & Equipment Hire",{"$f":"'Cash Flow (Crops & Livestock)'!C56","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F56","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I56","v":0}]
["Equipment Hire",{"$f":"'Cash Flow (Crops & Livestock)'!C57","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F57","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I57","v":0}]
["Custom Application",{"$f":"'Cash Flow (Crops & Livestock)'!C58","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F58","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I58","v":0}]
["Freight & Trucking",{"$f":"'Cash Flow (Crops & Livestock)'!C59","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F59","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I59","v":0}]
["Storage",{"$f":"'Cash Flow (Crops & Livestock)'!C60","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F60","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I60","v":0}]
["Utilities",{"$f":"'Cash Flow (Crops & Livestock)'!C61","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F61","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I61","v":0}]
["Irrigation",{"$f":"SUM(B29:B30)","v":0},{"$f":"SUM(C29:C30)","v":0},0]
["Repairs",{"$f":"'Cash Flow (Crops & Livestock)'!C63","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F63","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I63","v":0}]
["Fuel/Electricity",{"$f":"'Cash Flow (Crops & Livestock)'!C64","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F64","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I64","v":0}]
["Hired Labor",{"$f":"'Cash Flow (Crops & Livestock)'!C65","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F65","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I65","v":0}]
["Interest (Operating)",{"$f":"'Cash Flow (Crops & Livestock)'!C66","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F66","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I66","v":0}]
["Other (variable)",{"$f":"'Cash Flow (Crops & Livestock)'!C67","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F67","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I67","v":0}]
["Farm Insurance",{"$f":"'Cash Flow (Crops & Livestock)'!C72","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F72","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I72","v":0}]
["Real Estate Taxes",{"$f":"'Cash Flow (Crops & Livestock)'!C73","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F73","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I73","v":0}]
["Land Rent",{"$f":"'Cash Flow (Crops & Livestock)'!C74","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F74","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I74","v":0}]
["Depreciation (Economic)",{"$f":"'Cash Flow (Crops & Livestock)'!C76","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F76","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I76","v":0}]
["Other (fixed)",{"$f":"'Cash Flow (Crops & Livestock)'!C77","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F77","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I77","v":0}]
["Other (variable & fixed)",{"$f":"B38+B33","v":0},{"$f":"C38+C33","v":0},0]
["Income Taxes",{"$f":"'Cash Flow (Crops & Livestock)'!C84","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F84","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I84","v":0}]
["Owner Withdrawal",{"$f":"'Cash Flow (Crops & Livestock)'!C85","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F85","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I85","v":0}]
["Interest (Term)",{"$f":"'Cash Flow (Crops & Livestock)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cash Flow (Crops & Livestock)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Cash Flow (Crops & Livestock)'!#REF!","v":{"$error":"#REF!"}}]
["Interest (Oper & Term)",{"$f":"B42+B32","v":{"$error":"#REF!"}},{"$f":"C42+C32","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Principal Payment",{"$f":"'Cash Flow (Crops & Livestock)'!C86","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F86","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I86","v":0}]

{"sheet":"Optimization","index":8,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Optimizing Profitability"]
[null,null,"Budget Acres","Acres","Revenue Per Acre","Total Direct & Overhead Cost"]
[null,null,null,"(Enter Below)"]
["Crop 1",{"$f":"'Cash Flow (Crops & Livestock)'!C5","v":"Crop/Livestock 1"},{"$f":"'Cash Flow (Crops & Livestock)'!C11","v":0},295,{"$f":"'Cash Flow (Crops & Livestock)'!C17","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!C79","v":0}]
["Crop 2",{"$f":"'Cash Flow (Crops & Livestock)'!F5","v":"Crop/Livestock 2"},{"$f":"'Cash Flow (Crops & Livestock)'!F11","v":0},245,{"$f":"'Cash Flow (Crops & Livestock)'!F17","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!F79","v":0}]
["Crop 3",{"$f":"'Cash Flow (Crops & Livestock)'!I5","v":"Crop/Livestock 3"},{"$f":"'Cash Flow (Crops & Livestock)'!I11","v":0},98,{"$f":"'Cash Flow (Crops & Livestock)'!I17","v":0},{"$f":"'Cash Flow (Crops & Livestock)'!I79","v":0}]
[]
[null,null,null,null,"(Enter Below)"]
[null,"Minimum Costs to Cover",{"$f":"SUMPRODUCT(D4:D6,F4:F6)","v":0},"<=",350000,"¬ Total Cost (goal)"]
[null,"Minimum crop 1 acres",{"$f":"D4","v":295},">=",50,"¬ Minimum crop 1 acres (goal)"]
[null,"Minimum crop 2 acres",{"$f":"D5","v":245},">=",50,"¬ Minimum crop 2 acres (goal)"]
[null,"Minimum crop 3 acres",{"$f":"D6","v":98},">=",50,"¬ Minimum crop 3 acres (goal)"]
[null,"Acres",{"$f":"SUM(D4:D6)","v":638},"=",638,"¬ Maximum acres allowed"]
[]
[null,"Maximized Revenue",{"$f":"SUMPRODUCT(D4:D6,E4:E6)","v":0},"¬ Use Solver Function"]
[]
[]
[]
[]
[null,"Optimization Instructions"]
[null,"1. Enter the acres for consideration in the Optimizer in column D.  The acres already on the Crop Budget (Main) tab have been provided for comparison."]
[null,"2. Enter the maximum desired Revenue for the farm between all crops in column E."]
[null,"3. Enter the minimum goal of acres for each crop in column E.  "]
[null,"4. Enter the total acres to be planted across all crops in column E."]
[null,"5. Click on the Maximized Revenue cell in C17 and run the Solver tool (click on Data on the top toolbar).  Solver is pre-programmed, but can be reset using the photo below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6. After running Solver, the acres will be re-adjusted to maximize the revenue of the combined crops ."]

{"sheet":"Chemical Master List","index":9,"n_rows":170,"n_cols":22,"rows_kept":170,"cut":false,"hidden":true,"merged":[[1,8,1,13],[1,16,1,21],[83,0,83,3],[93,0,93,3],[116,0,116,3],[1,0,1,5],[93,16,93,19],[93,8,93,11],[116,8,116,11],[116,16,116,19]]}
[1,2,3,4,5,"6",null,null,1,2,3,4,5,"6",null,null,1,2,3,4,5,"6"]
["Corn Chemicals",null,null,null,null,null,null,null,"Soybean Chemicals",null,null,null,null,null,null,null,"Wheat Chemicals"]
["Name","App Unit","Rate Unit","Selling Unit","Timing","Site of Action",null,null,"Name","App Unit","Rate Unit","Selling Unit","Timing","Site of Action",null,null,"Name","App Unit","Rate Unit","Selling Unit","Timing","Site of Action"]
["None",null,1,"None","None",null,null,null,"None",null,1,"None","None",null,null,null,"None",null,1,"None","None"]
["Acuron","qt",4,"Gallon","Soil Premix","5/15/27/27",null,null,"Afforia","oz",16,"Pound","Soil Premix","2/2/14",null,null,"2,4-D Amine","pt",8,"Gallon",null,4]
["Acuron Flex","qt",4,"Gallon","Soil Premix","15/27/27",null,null,"Anthem Maxx","oz",128,"Ounce","Soil Premix","14/15",null,null,"2,4-D Ester","pt",8,"Gallon",null,"4"]
["Anthem ATZ","pt",8,"Gallon","Soil Premix","15/14/5",null,null,"Authority Assist","oz",128,"Ounce","Soil Premix","2/14",null,null,"Affinity Broadspec","oz",16,"Pound",null,"2/2"]
["Anthem Maxx","oz",128,"Ounce","Soil Premix","15/14",null,null,"Authority First/Sonic","oz",16,"Pound","Soil Premix","2/14",null,null,"Axial XL","oz",128,"Gallon",null,"1"]
["Armezon Pro","oz",128,"Ounce","Soil Premix","15/27",null,null,"Authority Maxx","oz",16,"Pound","Soil Premix","2/14",null,null,"Banvel/Clarity","pt",8,"Gallon",null,"4"]
["Atrazine (Dry)","lb",1,"Pound","Soil","5",null,null,"Authority MTZ","oz",16,"Pound","Soil Premix","5/14",null,null,"Buctril/Moxy","pt",8,"Gallon",null,6]
["Atrazine (Liquid)","qt",4,"Gallon","Soil","5",null,null,"Authority XL","oz",16,"Pound","Soil Premix","2/14",null,null,"Curtail","pt",8,"Gallon",null,"4/4"]
["Balance Flexx","oz",128,"Gallon","Soil","27",null,null,"Boundary","pt",8,"Gallon","Soil Premix","5/15",null,null,"Express","oz",16,"Pound",null,"2"]
["Basis Blend","oz",128,"Ounce","Soil Premix","2/2",null,null,"Broadaxe XC","oz",128,"Gallon","Soil","14/15",null,null,"Harmony","oz",16,"Pound",null,"2"]
["Bicip II Magnum Lite/Cinch ATZ Lite","qt",5,"Gallon","Soil Premix","5/15",null,null,"Canopy/Canopy Blend","oz",128,"Ounce","Soil Premix","2/2",null,null,"Harmony Extra","oz",16,"Pound",null,"2/2"]
["Bicip II Magnum/Cinch ATZ/Parallel Plus","qt",4,"Gallon","Soil Premix","5/15",null,null,"Command 3ME","pt",8,"Gallon","Soil","13",null,null,"Huskie","oz",128,"Gallon",null,"6/27"]
["Breakfree NXT ATZ/Harness XTRA/Keystone NXT","qt",4,"Gallon","Soil Premix","5/15",null,null,"Dual Magnum/Everprex/Parallel","pt",8,"Gallon","Soil","15",null,null,"MCPA","pt",8,"Gallon",null,"4"]
["Breakfree NXT Lite/Degree XTRA/Fultime NXT/Keystone LA NXT","qt",4,"Gallon","Soil Premix","5/15",null,null,"Engenia","oz",128,"Gallon","Soil","4",null,null,"Nimble","oz",16,"Pound",null,"2/2"]
["Breakfree NXT/Harness/Surpass NXT","pt",8,"Gallon","Soil","15",null,null,"Envive","oz",16,"Pound","Soil Premix","2/2/14",null,null,"Osprey","oz",16,"Pound",null,"2"]
["Callisto","oz",128,"Gallon","Soil","27",null,null,"Fierce","oz",16,"Pound","Soil Premix","14/15",null,null,"Peak","oz",16,"Pound",null,"2"]
["Corvus","oz",1,"Ounce","Soil Premix","2/27",null,null,"Fierce XLT","oz",16,"Pound","Soil Premix","2/14/15",null,null,"Powerflex HL","oz",16,"Pound",null,"2"]
["Dual II Magnum/Cinch/Parallel","qt",4,"Gallon","Soil","15",null,null,"Firstrate","oz",16,"Pound","Soil","2",null,null,"Prowl H20","pt",8,"Gallon",null,"3"]
["Fierce","oz",128,"Ounce","Soil Premix","14/15",null,null,"Flexstar GT 3.5","pt",8,"Gallon","Soil Premix","9/14",null,null,"Puma","pt",8,"Gallon",null,"1"]
["Harness Max","oz",128,"Ounce","Soil Premix","15/27",null,null,"Glyphosate","oz",128,"Gallon","Post",9,null,null,"Quelex","oz",16,"Pound",null,"2/4"]
["Hornet WDG/Stanza","oz",128,"Ounce","Soil Premix","2/4",null,null,"Lorox/Linex","lb",1,"Pound","Soil","7",null,null,"Starane Ultra","pt",8,"Gallon",null,"4"]
["Instigate","oz",128,"Ounce","Soil Premix","2/27",null,null,"Metribuzin","oz",16,"Pound","Soil","5",null,null,"Stinger","pt",8,"Gallon",null,"4"]
["Lexar EZ","qt",4,"Gallon","Soil Premix","5/27/15",null,null,"Optill","oz",16,"Pound","Soil Premix","2/14",null,null,"Talinor","oz",128,"Gallon",null,"6/27"]
["Lumax EZ","qt",4,"Gallon","Soil Premix","5/27/15",null,null,"Outlook","oz",128,"Gallon","Soil","15",null,null,"Widematch","pt",8,"Gallon",null,"4/4"]
["Outlook","oz",128,"Gallon","Soil","15",null,null,"Prefix","pt",8,"Gallon","Soil Premix","14/15"]
["Prequel","oz",128,"Ounce","Soil Premix","2/27",null,null,"Prowl H20/Prowl","pt",8,"Gallon","Soil","2"]
["Princep","qt",4,"Gallon","Soil","5",null,null,"Python/Accolade","oz",16,"Pound","Soil","2"]
["Prowl H20","pt",8,"Gallon","Soil","3",null,null,"Sonalan (PPI Only)","pt",8,"Gallon","Soil","3"]
["Python/Accolade","oz",128,"Gallon","Soil","2",null,null,"Spartan","oz",128,"Gallon","Soil","14"]
["Resicore","qt",4,"Gallon","Soil Premix","4/15/27",null,null,"Spartan Charge","oz",128,"Gallon","Soil Premix","14/14"]
["Resolve SG","oz",1,"Ounce","Soil","2",null,null,"Surveil","oz",16,"Pound","Soil Premix","2/14"]
["Sharpen","oz",128,"Gallon","Soil","14",null,null,"Synchrony XP","oz",16,"Pound","Soil Premix","2/2"]
["Surestart II/TripleFlex II","qt",4,"Gallon","Soil Premix","2/4/15",null,null,"Trifluralin (PPI Only)","pt",8,"Gallon","Soil","3"]
["Valor/Rowell","oz",128,"Gallon","Soil","14",null,null,"Trivence","oz",16,"Pound","Soil Premix","2/5/14"]
["Verdict","oz",128,"Gallon","Soil Premix","14/15",null,null,"Valor XLT/Rowl FX","oz",16,"Pound","Soil Premix","2/14"]
["Warrant","pt",8,"Gallon","Soil","9",null,null,"Valor/Valor EZ/Rowel","oz",128,"Gallon","Soil","14"]
["Zemax","qt",4,"Gallon","Soil Premix","27/15",null,null,"Verdict","oz",128,"Gallon","Soil Premix","14/15"]
["Zidua","oz",1,"Gallon","Soil","15",null,null,"Warrant","pt",8,"Gallon","Soil","9"]
[null,null,null,null,null,null,null,null,"Warrant Ultra","oz",128,"Gallon","Soil Premix","14/15"]
["None",null,1,"None","Post",null,null,null,"Xtendimax/Fexapan","oz",128,"Gallon","Soil","4"]
["2,4-D","pt",8,"Gallon","Post",4,null,null,"Zidua","oz",1,"Gallon","Soil","15"]
["Accent Q","oz",1,"Ounce","Post",2,null,null,"Zidua Pro","oz",128,"Gallon","Soil Premix","2/14/15"]
["Aim","oz",1,"Ounce","Post",14]
["Anthem ATZ","pt",8,"Gallon","Post Pre-Mix","15/14/5",null,null,"None",null,1,"None","Post"]
["Anthem Maxx","oz",128,"Gallon","Post Pre-Mix","15/14",null,null,"Anthem Maxx","oz",128,"Gallon","Post","14/15"]
["Armezon Pro","oz",128,"Ounce","Post Pre-Mix","15/27",null,null,"Assure II/Targa","oz",128,"Gallon","Post",1]
["Armezon/Impact","oz",128,"Ounce","Post",27,null,null,"Basagran/Broadloom","pt",8,"Gallon","Post",6]
["Atrazine (Dry)","lb",1,"Pound","Post",5,null,null,"Cadet","oz",16,"Pound","Post",14]
["Atrazine (Liquid)","qt",4,"Gallon","Post",5,null,null,"Cheetah Max","qt",4,"Gallon","Post","10/14"]
["Banvel/Clarity","pt",8,"Gallon","Post",4,null,null,"Classic","oz",16,"Pound","Post",2]
["Basagran/Broadloom","pt",8,"Gallon","Post",6,null,null,"Cobra","oz",128,"Gallon","Post",14]
["Beacon","oz",1,"Ounce","Post",2,null,null,"Engenia","oz",128,"Gallon","Post","4"]
["Buctril/Moxy","pt",8,"Gallon","Post",6,null,null,"Firstrate","oz",16,"Pound","Post",2]
["Cadet","oz",128,"Quart","Post",14,null,null,"Flexstar","pt",8,"Gallon","Post",14]
["Callisto","oz",128,"Gallon","Post",27,null,null,"Flexstar GT 3.5","pt",8,"Gallon","Post","9/14"]
["Callisto GT","pt",8,"Gallon","Post Pre-Mix","9/27",null,null,"Fusilade DX","oz",128,"Gallon","Post",1]
["Callisto XTRA","oz",128,"Gallon","Post Pre-Mix","5/27",null,null,"Fusion","pt",8,"Gallon","Post",1]
["Capreno","oz",1,"Ounce","Post Pre-Mix","2/27",null,null,"Glyphosate","oz",128,"Gallon","Post",9]
["DiFlexx","oz",128,"Gallon","Post",4,null,null,"Harmony SG","oz",16,"Pound","Post",2]
["DiFlexx Duo","oz",128,"Gallon","Post Pre-Mix","4/27",null,null,"Liberty/Cheetah","oz",128,"Gallon","Post","10"]
["Enlist Duo","pt",8,"Gallon","Post Pre-Mix","4/9",null,null,"Marvel","oz",128,"Gallon","Post","14/14"]
["Enlist One","pt",8,"Gallon","Post","4",null,null,"Phoenix","oz",128,"Gallon","Post",14]
["Expert","qt",4,"Gallon","Post Pre-Mix","5/9/15",null,null,"Poast/Poast Plus","oz",128,"Gallon","Post",1]
["Glyphosate","oz",128,"Gallon","Post",9,null,null,"Prefix","pt",8,"Gallon","Post","14/15"]
["Halex GT","pt",8,"Gallon","Post Pre-Mix","9/15/27",null,null,"Pursuit","oz",128,"Gallon","Post",2]
["Hornet WDG/Stanza","oz",128,"Gallon","Post Pre-Mix","2/4",null,null,"Raptor","oz",128,"Gallon","Post",2]
["Laudis","oz",1,"Ounce","Post",27,null,null,"Reflex","pt",8,"Gallon","Post",14]
["Liberty","oz",128,"Gallon","Post",10,null,null,"Resource","oz",128,"Gallon","Post",14]
["Permit","oz",16,"Pound","Post",2,null,null,"Select Max/Arrow/Select","oz",128,"Gallon","Post",1]
["Realm Q","oz",128,"Gallon","Post Pre-Mix","2/27",null,null,"Sequence","pt",8,"Gallon","Post","9/15"]
["Resolve Q","oz",128,"Gallon","Post Pre-Mix","2/2",null,null,"Synchrony XP","oz",16,"Pound","Post","2/2"]
["Resource","oz",128,"Gallon","Post",14,null,null,"Ultra Blazer","pt",8,"Gallon","Post",14]
["Revulin Q","oz",128,"Gallon","Post Pre-Mix","2/27",null,null,"Warrant Ultra","oz",128,"Gallon","Post","14/15"]
["Sequence","pt",8,"Gallon","Post Pre-Mix","9/15",null,null,"Xtendimax/Fexapan","oz",128,"Gallon","Post","4"]
["Solstice","oz",128,"Gallon","Post Pre-Mix","14/27"]
["Status","oz",1,"Ounce","Post Pre-Mix","4/19"]
["Steadfast Q","oz",128,"Gallon","Post Pre-Mix","2/2"]
["Stinger","oz",128,"Gallon","Post",4]
["Yukon","oz",128,"Gallon","Post Pre-Mix","2/4"]
[]
["Adjuvants"]
["None",null,1,"None"]
["Ammonium Sulfate","lb",1,"Pound"]
["Ammonium Sulfate (Liquid)","pt",8,"Gallon"]
["Ammonium Sulfate (Replacement)","pt",8,"Gallon"]
["Crop Oil Concentrate","oz",1,"Gallon"]
["Drift Agent/Spreader","oz",128,"Gallon"]
["Methylated Seed Oil (MSO)","qt",4,"Gallon"]
[]
[]
["Corn Fungicides",null,null,null,null,null,null,null,"Soybean Fungicides",null,null,null,null,null,null,null,"Wheat Fungicides"]
["None",null,1,"None",null,null,null,null,"None",null,1,"None",null,null,null,null,"None",null,1,"None"]
["Affiance 1.5 SC","oz",128,"Gallons",null,null,null,null,"Absolute Maxx SC","oz",128,"Gallons",null,null,null,null,"Absolute Maxx SC","oz",128,"Gallons"]
["Aproach 2.08 SC","oz",128,"Gallons",null,null,null,null,"Aproach Prima SC","oz",128,"Gallons",null,null,null,null,"Aproach Prima SC","oz",128,"Gallons"]
["Aproach Prima 2.34 SC","oz",128,"Gallons",null,null,null,null,"Aproach SC","oz",128,"Gallons",null,null,null,null,"Aproach SC","oz",128,"Gallons"]
["Domark 230 ME","oz",128,"Gallons",null,null,null,null,"Caramba 0.75 SL","oz",128,"Gallons",null,null,null,null,"Caramba 0.75 SL","oz",128,"Gallons"]
["Folicur 3.6 F","oz",128,"Gallons",null,null,null,null,"Delaro 325 SC","oz",128,"Gallons",null,null,null,null,"Delaro 325 SC","oz",128,"Gallons"]
["Fortix/Preemptor 3.22 SC","oz",128,"Gallons",null,null,null,null,"Evito SC","oz",128,"Gallons",null,null,null,null,"Evito SC","oz",128,"Gallons"]
["Headline 2.09 EC/SC","oz",128,"Gallons",null,null,null,null,"Folicur 3.6 F","oz",128,"Gallons",null,null,null,null,"Folicur 3.6 F","oz",128,"Gallons"]
["Headline AMP 1.68 SC","oz",128,"Gallons",null,null,null,null,"Headline SC","oz",128,"Gallons",null,null,null,null,"Headline SC","oz",128,"Gallons"]
["Priaxor 4.17 SC","oz",128,"Gallons",null,null,null,null,"Nexicor EC","oz",128,"Gallons",null,null,null,null,"Nexicor EC","oz",128,"Gallons"]
["Proline 480 SC","oz",128,"Gallons",null,null,null,null,"Preemptor SC","oz",128,"Gallons",null,null,null,null,"Preemptor SC","oz",128,"Gallons"]
["Quadris 2.08 SC","oz",128,"Gallons",null,null,null,null,"Priaxor","oz",128,"Gallons",null,null,null,null,"Priaxor","oz",128,"Gallons"]
["Quilt Xcel 2.2 SE","oz",128,"Gallons",null,null,null,null,"Proline 480 SC","oz",128,"Gallons",null,null,null,null,"Proline 480 SC","oz",128,"Gallons"]
["Stratego  YLD 4.18 SC","oz",128,"Gallons",null,null,null,null,"Prosaro 421 SC","oz",128,"Gallons",null,null,null,null,"Prosaro 421 SC","oz",128,"Gallons"]
["Tilt 3.6 EC","oz",128,"Gallons",null,null,null,null,"Quilt Xcel 2.2 SE","oz",128,"Gallons",null,null,null,null,"Quilt Xcel 2.2 SE","oz",128,"Gallons"]
["Trivapro A 0.83 + Trivapro B 2.2 SE","oz",128,"Gallons",null,null,null,null,"Stratego YLD","oz",128,"Gallons",null,null,null,null,"Stratego YLD","oz",128,"Gallons"]
[null,null,null,null,null,null,null,null,"Tilt 3.6 EC","oz",128,"Gallons",null,null,null,null,"Tilt 3.6 EC","oz",128,"Gallons"]
[null,null,null,null,null,null,null,null,"Trivapro SE","oz",128,"Gallons",null,null,null,null,"Trivapro SE","oz",128,"Gallons"]
[]
[]
[]
[]
["Insecticides",null,null,null,null,null,null,null,"Soybean Insecticides",null,null,null,null,null,null,null,"Insecticides"]
["None",null,1,"None",null,null,null,null,"None",null,1,"None",null,null,null,null,"None",null,1,"None"]
["Insecticide (pint rate)","pt",8,"Gallon",null,null,null,null,"Insecticide (pint rate)","pt",8,"Gallon",null,null,null,null,"Insecticide (pint rate)","pt",8,"Gallon"]
["Insecticide (ounce rate)","oz",1,"Gallon",null,null,null,null,"Insecticide (ounce rate)","oz",1,"Gallon",null,null,null,null,"Insecticide (ounce rate)","oz",1,"Gallon"]
["Insecticide (pound rate)","lb",1,"Pound",null,null,null,null,"Insecticide (pound rate)","lb",1,"Pound",null,null,null,null,"Insecticide (pound rate)","lb",1,"Pound"]
["Insecticide (quart rate)","qt",4,"Gallon",null,null,null,null,"Insecticide (quart rate)","qt",4,"Gallon",null,null,null,null,"Insecticide (quart rate)","qt",4,"Gallon"]
[]
[]
["None",null,1,"None",null,null,null,null,"None",null,1,"None",null,null,null,null,"None",null,1,"None"]
["Ambush 25W","oz",1,"Gallon",null,null,null,null,"Ambush 25W","oz",1,"Gallon",null,null,null,null,"Baythroid XL","oz",1,"Gallon"]
["Arctic 3.2 EC","oz",1,"Gallon",null,null,null,null,"Arctic 3.2 EC","oz",1,"Gallon",null,null,null,null,"Dimethoate 4EC / 400 (5lb)","lb",5,"Pound"]
["Asana XL","oz",1,"Gallon",null,null,null,null,"Asana XL","oz",1,"Gallon",null,null,null,null,"Dimethoate 4EC / 400 (gal)","pt",8,"Gallon"]
["Aztec 2.1G","oz",1,"Gallon",null,null,null,null,"Baythroid 2","oz",1,"Gallon",null,null,null,null,"Lannate LV (lb)","lb",1,"Pound"]
["Aztec 4.67G","oz",1,"Gallon",null,null,null,null,"Baythroid XL","oz",1,"Gallon",null,null,null,null,"Lannate LV(oz)","oz",1,"Gallon"]
["Baythroid 2 & XL","oz",1,"Gallon",null,null,null,null,"Bifenture EC","oz",1,"Gallon",null,null,null,null,"Malathion 5EC, 8F and 8 Aquamul","pt",8,"Gallon"]
["Bifenture EC","oz",1,"Gallon",null,null,null,null,"Brigade 2EC","oz",1,"Gallon",null,null,null,null,"Mustang Maxx EC & EW","oz",1,"Gallon"]
["Brigade 2EC","oz",1,"Gallon",null,null,null,null,"Capture 2EC","oz",1,"Gallon",null,null,null,null,"Radiant SC ","oz",1,"Gallon"]
["Capture 1.15 G","oz",1,"Gallon",null,null,null,null,"Carbaryl 4L","pt",8,"Gallon",null,null,null,null,"Sevin 4 F and XLR Plus","qt",4,"Gallon"]
["Capture 2EC","oz",1,"Gallon",null,null,null,null,"Chlorpyrifos 4E","pt",8,"Gallon",null,null,null,null,"Tracer","oz",1,"Gallon"]
["Capture LFR ","oz",1,"Gallon",null,null,null,null,"Cobalt","oz",1,"Gallon",null,null,null,null,"Warrior","oz",1,"Gallon"]
["Cobalt","oz",1,"Gallon",null,null,null,null,"Dimethoate 267","pt",8,"Gallon"]
["Comite","pt",8,"Gallon",null,null,null,null,"Dimethoate 4EC and DiGon 400","pt",8,"Gallon"]
["Counter 15G","oz",1,"Gallon",null,null,null,null,"Dimilin 25W & 2L","oz",1,"Gallon"]
["Counter CR","oz",1,"Gallon",null,null,null,null,"Entrust","oz",1,"Gallon"]
["Deadline MPs 4% bait","lb",50,"Pound",null,null,null,null,"Intrepid 2F","oz",1,"Gallon"]
["Dimethoate 267","pt",8,"Gallon",null,null,null,null,"Lambda-Cy EC","oz",1,"Gallon"]
["Dimethoate 4EC / 400 (5lb)","lb",5,"Pound",null,null,null,null,"Lannate LV(oz)","oz",1,"Gallon"]
["Dimethoate 4EC / 400 (gal)","pt",8,"Gallon",null,null,null,null,"Lannate LV (lb)","lb",1,"Pound"]
["Dimethoate 5lb","oz",1,"Gallon",null,null,null,null,"Larvin 3.2","oz",1,"Gallon"]
["Empower 2","lb",1,"Pound",null,null,null,null,"Leverage 2.7","oz",1,"Gallon"]
["Entrust ","oz",1,"Gallon",null,null,null,null,"Leverage 360","oz",1,"Gallon"]
["Force 3G","oz",1,"Gallon",null,null,null,null,"Lorsban 4E & Advanced","pt",8,"Gallon"]
["Fortress 5G","oz",1,"Gallon",null,null,null,null,"Mustang Maxx EC & EW","oz",1,"Gallon"]
["Intrepid 2F","oz",1,"Gallon",null,null,null,null,"Nufos 4E","pt",8,"Gallon"]
["Lambda-Cy EC","oz",1,"Gallon",null,null,null,null,"Orthene 75S","lb",1,"Pound"]
["Lannate LV","pt",8,"Gallon",null,null,null,null,"Orthene 90S","lb",1,"Pound"]
["Lorsban 15G ","oz",1,"Gallon",null,null,null,null,"Orthene 97","lb",1,"Pound"]
["Lorsban 4E & Advanced","pt",8,"Gallon",null,null,null,null,"Penncap-M","pt",8,"Gallon"]
["Malathion 5EC, 8F and 8 Aquamul","pt",8,"Gallon",null,null,null,null,"Permethrin/ Perm-Up 3.2EC","oz",1,"Gallon"]
["Malathion ULV","oz",1,"Gallon",null,null,null,null,"Pounce 25WP & 3.2 EC","oz",1,"Gallon"]
["Mustang Maxx EC and EW","oz",1,"Gallon",null,null,null,null,"Proaxis","oz",1,"Gallon"]
["Perm-UP 3.2 EC","oz",1,"Gallon",null,null,null,null,"Radiant SC","oz",1,"Gallon"]
["Pounce 25 WP","oz",1,"Gallon",null,null,null,null,"Sevin 4 F and XLR Plus","qt",4,"Gallon"]
["Pounce 3.2 EC","oz",1,"Gallon",null,null,null,null,"Sevin 80S and 80WSP","lb",1,"Pound"]
["Proaxis","oz",1,"Gallon",null,null,null,null,"Silencer","oz",1,"Gallon"]
["Radiant SC ","oz",1,"Gallon",null,null,null,null,"Tracer","oz",1,"Gallon"]
["Regent 4SC","oz",1,"Gallon",null,null,null,null,"Warrior","oz",1,"Gallon"]
["Sevin 4F and XLR Plus ","qt",4,"Gallon"]
["Sevin 80S and 80WSP","lb",1,"Pound"]
["Silencer","oz",1,"Gallon"]
["Warrior","oz",1,"Gallon",null,null,null,null,"http://msuent.com/assets/pdf/1582SoybeanInsects10.pdf"]
[]
[]
["http://msuent.com/assets/pdf/1582CornInsects10.pdf"]